Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Storing distinct field values as JS variables without knowing the data content

Aclypse10
Level 1
Level 1

Hi guys,

 

I'm trying to create a Split activity based on distinct values of fielddata. I'm trying to fetch city centre data from regions. I tried this in JS:

 

var query = xtk.queryDef.create(
<queryDef schema="temp:enrich3" operation="select" distinct="true">
<select>
<node expr="city"/>
</select>
</queryDef>);
var resultSet = query.ExecuteQuery();
for each (var row in resultSet)
{​​​​​
vars.city = row.city;
logInfo(vars.city);
}​​​​​

 

This will return the following:

 

12/11/2020 09:57:21 PIJNACKER
12/11/2020 09:57:21 BLEISWIJK
12/11/2020 09:57:21 BERGSCHENHOEK
12/11/2020 09:57:21 ROTTERDAM
12/11/2020 09:57:21 DELFGAUW
12/11/2020 09:57:21 Pijnacker-Nootdorp
12/11/2020 09:57:21 BERKEL EN RODENRIJS
12/11/2020 09:57:21 NOOTDORP
12/11/2020 09:57:21 DELFT


I want each and every one of these values to be stored seperately with some kind of linenumber/rownumber so I can select them in a Split activity by saying something like vars.city1 is not empty and so on.

 

How can I do this?

1 Reply
Jonathon_wodnicki
Community Advisor
Community Advisor

Hi,

 

You'd need to use initialization script of split (or cells?) activity to dynamically alter the activity's transitions.

What is the goal of splitting on city?

 

Thanks,

-Jon

Aclypse10
Level 1
Level 1

Thanks, what would I put in there? I want for each variation to output a DM file in the end. The problem is that on forehand you do not know how many cities are held in the target. I target on regioncodes, so in advance I do not know how many cities belong to a specific regioncode. But for every city that comes out the target eventually, I want a seperate file to be generated for direct marketing activities.