I have a row with an ID, a start number and end number, like:
ID START END
1 2 10
I need to convert this row in N rows,with the same ID for all lines and the column NUMBER must be between the column START and column END, in this case column NUMBER will be between 2 and 10. For example:
I tried it with a tjavarow but it don´t generate rows, only transform the input row.
You need to do a loop with tLoop based on the row data, the job looks like:
tFixedFlowInput: generate the current row.
Let me know if you need more help in detail.
Finally, I did it with trowgenerator and tmap. I crossed my data with the trowgenerator. Trowgenerator generate the numbers between 1 and 1000.
If I do an iterate i think it was be very slow.
Thanks for all your help.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Watch the recorded webinar!
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables