DSXchange

Hello all,

Can someone please let me know if they have implemented a OR condition in Lookup.

One Primary link----with 3 columns

first secondary link----with 1 column
second secondary link----with 1 column
third secondary link----with 1 column

The first column in Primary link looked up with column in first secondary link
The second column in Primary link looked up with column in second secondary link
The third column in Primary link looked up with column in third secondary link

Now, I need an OR condition between these. if we just do a lookup we have AND condition.

Thanks in Advace

Not in the Lookup stage, but you can in a downstream Transformer stage. Remember the philosophy "one task, one stage type". Lookup stages do lookups. That's all.

Thanks Ray...