I have a text file (pipe delimited) with 3 rows. I am combining these 3 rows with a ',' (comma) as delimiter via Execute Command Stage. I am passing the output of the execute command to the Start Loop to define delimited values.
Issue: When running the job, 3 iterations are performed as expected but only first row is being passed in all those 3 iterations. Not sure why start loop activity is not picking all 3 rows.
I designed a sequencer job as below:
Code: Select all
ExecuteCommand --> UserVariableActivity (to Trim @FM) --> StartLoopActivity (Defined output from UserVariableActivity) --> UserVariableActivity (To set values from the row to the columns in table) --> Parallel_Job --> End Loop Activity
Row1: AB|CD
Row2: EF|GH
Row3: IJ|KL
Single Row: AB|CD,EF|GH,IJ|KL
When passing the above row into the loop only AB|CD row is being processed 3 times.
Any help in this regards is much appreciated.
Thanks.