Hi everybody, i'd like to make a Do..while loop. The condition is the number of records coming from a query.
Do you know if there are any samples to watch?
Simplest solution is to use a tFlowToIterate component. dbInput--row1-->tFlowToIterate--iterate--> you can access the values inside the row for each iteration by retrieving from the globalMap. Values are keyed by the row/column that are input to the tFlowToIterate, so in the example above you would use: globalMap.get("row1.COLUMN")
Thanks to you too Sabrina and JohnGarrettMartin,
i'm using
dbInput--row1-->tFlowToIterate--iterate-->tMysqlRow...
to manage my job.
Thanks.
I succeed and wrote about it, here:
http://www.talendforge.org/forum/edit.php?id=120842