Look up

yarlly · Post by **yarlly** » Tue Aug 05, 2008 10:56 am

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

DS_SUPPORT · Post by **DS_SUPPORT** » Tue Aug 05, 2008 11:15 am

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.

satya99 · Post by **satya99** » Tue Aug 05, 2008 2:54 pm

viewtopic.php?t=118893&highlight=Refere ... +generated

ray.wurlod · Post by **ray.wurlod** » Tue Aug 05, 2008 4:07 pm

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