DSXchange

Hi All,


I am trying to lookup 2 tables to load my target Sequential file,but i am getting a warning


Untitled4..Transformer_22: Reference lookup generated 4 rows. Only the last row was used.

I am using the Trim Function in my Source SQL,when I am Extracting the Data

Any Help Please

Thanks
yar

In your ODBC lookup, for the lookup condition you are using, there are 4 rows. Check your lookup condition and change it accordingly, so that you can get 1 row as output.

Or, if you need all four rows, check the "multiple row return" check box.