Lookup Stage - Multiple Keys

Raftsman · Post by **Raftsman** » Thu Nov 16, 2006 9:14 am

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

ray.wurlod · Post by **ray.wurlod** » Thu Nov 16, 2006 9:24 am

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.