Talend loop for each record

Question

Hi i am designing a data generation job. my job is something like this

tRowGenerate --> tMap --> tFileOutputDelimited.

Lets say my tRowGenerate produces 5 columns with 2 records. I want to iterate for this records i.e for each record I want to iterate certain number of times.

for record 1 iterate 5 times to produce further data.

for record 2 iterate 3 times to produce further data.

enter image description here

Please suggest how to apply this multiply by xi logic. where xi for each record can change.

Thanks!

Do you need to be able to choose how many times the first row is duplicated etc or are you happy for it to be random? — ydaetskcoR, Oct 16 '14 at 11:40
The value for it will be decided by a function based on business rule. I will write a custom routine for it. — Kaushal, Oct 16 '14 at 11:50
possible duplicate of [Talend - generating n multiple rows from 1 row](http://stackoverflow.com/questions/26365036/talend-generating-n-multiple-rows-from-1-row) — ydaetskcoR, Oct 17 '14 at 13:55

score 3 · Accepted Answer · edited Oct 31 '14 at 08:39

If you want to loop on the data generated from the tRowGenerator you can use a tLoop where you put the call to your business rule to determine the number of loops or when stop looping.

An example job might look like:

Example job layout and tLoop configuration

Logic of flow:

row1 is a main connection taking the generated values to the tFlowtoIterate that stores them in global variables;
the iterate link activates the tLoop that can use the values stored in the global vars to activate your business rule (to have the number of loops or tho ask if continue or stop);
the tLoop activate the tJavaFlex that uses the stored global vars to produce the output you like and pass it to the tFileOutputDelimited with a main link (row2).

You have to activate the append flag on the tFileOutputDelimited to keep the data from the different loops. If you need you can add a tFileDelete at the beginning to empty the output file before a new processing round.

Thank you @ydaetskcoR for inlining the images. Hopefully now with more than 15 reputation I can add them directly. :) — RobMcZag, Oct 31 '14 at 08:46

Talend loop for each record

1 Answers1