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

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

How do I iterate a sql from the same db

Hi community

 

I have the following scenario:

Select id from db1 

then iterate id to select from the same db1 source and table

 

I have placed the following in my job 

 

tmysqlinput -> iterateflow -> tfixedflowinput -> tmysqlrow-> tmap->tmysqloutput

 

Does this look correct ?

Labels (3)
11 Replies
vapukov
Master II
Master II

check the answer for Your other question

Anonymous
Not applicable
Author

Not the same question, the other question relates to tPostgresqlRow usage and failure.

 

I managed to get the job to work - thanks for your input and assistance, it did help solve the problem

0683p000009LwNP.png