HI,
I have two columns in the source that needs to be looked up to a single column in the reference. Can this be done in a single stage or we need to use multiple lookup stages.
Even if one of the lookups fail, i need that record in the reject link.
multiple lookup
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Neither will work given your requirement. You need a Transformer stage upstream of the lookup stage to combine the two columns appropriately into one. Then perform the lookup using that one.
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.
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
OK, clearly I did not understand what you had in mind. I understood you had one row in the reference, value xxxyyy.
Your clarified requirement needs two separate lookups.
Your clarified requirement needs two separate lookups.
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.
-
- Participant
- Posts: 3337
- Joined: Mon Jan 17, 2005 4:49 am
- Location: United Kingdom