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
Lookup scenario with duplicate keys in the reference table
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
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.
Open the Lookup Stage Conditions and choose the reference link name from the "Multiple rows returned from link" drop-down list.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.