Is it possible to search on multiple keys within one lookup stage. I use the same code table for two different fields from the same source
i.e. field1 = code.fieldA or
field2 = code.fieldA
Thanks
Lookup Stage - Multiple Keys
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
You can not do the OR in a Lookup stage. You can do two separate lookups to the same source, and join the two result sets downstream.
This is more cleanly designed using two separate Lookup stages.
This is more cleanly designed using two separate Lookup stages.
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.