How to draw and use parameters on an iterate flow connection

One Star

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
Seven Stars

Re: How to draw and use parameters on an iterate flow connection

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