Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us in Toronto Sept 9th for Qlik's AI Reality Tour! Register Now
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

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?
Labels (2)
3 Replies
Anonymous
Not applicable
Author

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")
Anonymous
Not applicable
Author

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