Page 1 of 1

Lookup Stage - Multiple Keys

Posted: Thu Nov 16, 2006 9:14 am
by Raftsman
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

Posted: Thu Nov 16, 2006 9:24 am
by ray.wurlod
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.