Reference lookup generated 2 rows

MURALI123 · Post by **MURALI123** » Tue Oct 13, 2009 2:26 pm

Hi
Cany anybody help me in the below Issue:

Reference lookup generated 2 rows. Only the last row was used.

Regards,
Malli

IBM Analytics Champion 2009 - 2020 · Post by **asorrell** » Tue Oct 13, 2009 2:53 pm

Pretty much exactly what it said. In your lookup, two different rows matched whatever id was being looked up, so it used the values from the 2nd (last) row to satisfy the lookup condition.

You'll need to go to your lookup source and see if there's a problem that is causing two rows to match. Depending on the source, you might need to modify the SQL (ie: return DISTINCT) or add steps to remove the duplicates in the job to get rid of the message.

Kryt0n · Post by **Kryt0n** » Tue Oct 13, 2009 3:43 pm

Or if you want both successful lookups to produce output, either use a join or select the link in the "Link returns multiple rows" box within the lookup stage.

chulett · Post by **chulett** » Tue Oct 13, 2009 4:43 pm

Server job, so if you really want a 'multi-row result set' you'll need to use an ODBC or UV stage.

Kryt0n · Post by **Kryt0n** » Tue Oct 13, 2009 4:55 pm

chulett wrote:Server job...

Doh! One day i will learn to look at that bit...