topic Re: Do..while loop based on number of records in Talend Studio

Do..while loop based on number of records

Anonymous — Fri, 13 Sep 2013 11:03:21 GMT

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?

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

Anonymous — Fri, 13 Sep 2013 11:19:27 GMT

Hi,
Perhaps these related forums will be helpful for you
https://community.talend.com/t5/Design-and-Development/resolved-Loop-Repeat-if-there-is-an-error/td-p/104427, https://community.talend.com/t5/Design-and-Development/How-to-Wait-for-an-Email-attachment/td-p/99901
Best regards
Sabrina

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

Anonymous — Fri, 13 Sep 2013 19:29:24 GMT

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

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

Anonymous — Fri, 25 Oct 2013 16:31:36 GMT

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