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