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

Announcements
Write Table now available in Qlik Cloud Analytics: Read Blog
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

How to draw and use parameters on an iterate flow connection

I'm having a little trouble figuring out how to use tXXXRow components being fed from another query and / or parsed file.
Lets say we have an tOracleInput component named "Input" which produces a result set with a string column called "PersonName". How do we use the "Name" result from each row in a query on the tOracleRow component?
A concrete example would be greatly appreciated!
Thanks
Labels (2)
1 Reply
alevy
Specialist
Specialist

If your job is tOracleInput --row1--> tOracleRow, then create the SQL in tOracleRow like the following example (although you wouldn't use tOracleRow for a select statement generally).
"SELECT * FROM Customers WHERE PersonName="+row1.PersonName