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.
Try Talend Cloud free for 30 days.
Introduction to Talend Open Studio for Data Integration.
Practical steps to developing your data integration strategy.
Create systems and workflow to manage clean data ingestion and data transformation.