Implementation of OR Logic

[mc_harsha]

Hi,

Can you please provide me info how to implement OR condition in lookups.

Ex:

Select * from table1
where table1.col1 in (select col1 from table2) or
table1.col1 in (select col1 from table3);

Regards,
harsha

[Minhajuddin]

You can use sparse lookups for this kind of stuff. But, again it would not be good on performance if your input data is huge...

Gotta wait for the gurus

[DSguru2B]

Build your lookup dataset or if you are using the join stage, in your reference join, use a UNION of col1 from table2 and table3. This way you will have all your values that need to be looked up upon from your input data.

[challahari]

What stages are you using to accomplish your task. We can guide you If you give us info on it.

Thanks.