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

What’s New for Talend Spring ’19

Watch the recorded webinar!

Watch Now

Tutorial

Introduction to Talend Open Studio for Data Integration.

Watch

Downloads and Trials

Test drive Talend's enterprise products.

Downloads

Definitive Guide to Data Integration

Practical steps to developing your data integration strategy.

Download