Lookup scenario with duplicate keys in the reference table

sg33 · Post by **sg33** » Wed Nov 25, 2015 8:14 am

Hi -

There is a scenario in one of the new requirement of our project:

The input stream has columns COLA and COLB, COLB is the key column. The reference link has COLB and COLC.

I want to do a left outer join based on COLB but COLB has duplicate entries in the reference link. The values for COLC are different for these duplicate key values. I want to take both the values for COLC based on the lookup key and then run a search on another table for these values from COLC.

Is there any simple approach to achieve this?

Thanks

ray.wurlod · Post by **ray.wurlod** » Wed Nov 25, 2015 2:57 pm

The Lookup stage permits return of multiple rows from one reference link.

Open the Lookup Stage Conditions and choose the reference link name from the "Multiple rows returned from link" drop-down list.

anbu · Post by **anbu** » Fri Dec 04, 2015 2:41 am

If you use Join stage, you will get all the duplicate values by default