Do..while loop based on number of records

One Star

Do..while loop based on number of records

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?
Moderator

Re: Do..while loop based on number of records

Hi,
Perhaps these related forums will be helpful for you
Forum29065, Forum 17238
Best regards
Sabrina
--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.

Re: Do..while loop based on number of records

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")
One Star

Re: Do..while loop based on number of records

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