Skip to main content

Hi, I have a workbench which is fed by a set of user parameters. It produces a dataset of 10.000+ buildings for a chosen municipality and extraction date. 

Is it possible to create an input which loops through these user parameters:

Userparameter 1: City

Userparameter 2: Extraction date

Run City Date
1 A 2020-01-01
2 B 2020-01-01
3 C 2020-01-01

 

Workbench should behave like first run City A with first date, than City B with 2nd date, than City C with third date

Could you not just use say a delimited text string of values?

Eg. Setting a Published “CITY” Parameter to 
 


Then get 3 x Exe​​​​cution Features with the City Names (Similarly can do with a Delimited DATE Parameter).

These can be fed into the Downstream Transformers to execute in Eg. Transformers set to run in Group Processing Mode Batches.

Thanks also @ebygomm  for the RegEx for reliably detecting delimiters 😉:
insert_delimiter_character/string_here(?=(?:e^\"]*\"t^\"]*\")*?^\"]*$)



Eg. Sample to use these Features to Initiate some other activity, like Reading Features in with just WHERE City = @Value(_CITY)

 

 


There are multiple options.

Most easy would be to setup the logic to work with city and date as user parameter (this one lets call the child). Then create a master workspace that uses a workspace runner to run the child. In the master you create logic to have city and date as an attribute that you feed to the child. This way the child will be triggered x amount of times depending on the combinations you have.

 

Other option is to wrap your logic that you want to ‘loop’ into a custom transformer and set the correct group by attributes. Not sure how it works if you have multiple attributes that you need to provide.

 

Easiest way is the workspace runner


Reply