Passing Delimited List of Values to StartLoop

[lawrencetaylor]

Hi all,

I am trying to extract a list of values from a database, and pass it to a StartLoop activity to execute a Job repetitively for each value in the list.

I can extract the data and construct the list in a parallel job, but I cannot feed the the data in a field (or, alternatively, in a file containing the list) into the StartLoop activity.

How can I create an output parameter from a parallel job, or set the value of a Sequence parameter within a parallel job? Or, alternatively, how can I get the data in a file into a parameter so it can be seen by the StartLoop activity?

TIA

Larry Taylor

[chitravallivenkat]

Get the value in variable and seperate the value from the variable using sequence number and delimiter used in the value.

[chulett]

A file should work fine. Build a routine to 'type' the file and send back the output, then call the routine in a UserVariables Activity stage. The Start Loop can then leverage the delimited list quite easily.

[ray.wurlod]

In one of the forthcoming training DVDs from DSXchange Learning Center this technique is shown.

[lawrencetaylor]

Okay, I have added an ExecCommand activity that uses "cat" to list the file into the $CommandOutput variable.

Thanks!

[chulett]

If that fixed your problem, please mark the post as Resolved using the button at the top of the screen.