OR operation in Look Up Stage

deepa_shenoy · Post by **deepa_shenoy** » Tue Nov 03, 2009 2:31 am

Hi,

Is it possible to use a single Lookup stage for looking up two tables and allow the records to pass if its finds a match in either of the tables.

In other words, I want an OR operation to work on the looked up columns and not an AND operation.

Thanks in advance.

Deepa

ray.wurlod · Post by **ray.wurlod** » Tue Nov 03, 2009 2:53 am

Yes and no. You can perform the two lookups, but you can not do either of AND or OR in a Lookup stage. The test must be in a downstream Transformer or Filter stage.

deepa_shenoy · Post by **deepa_shenoy** » Tue Nov 03, 2009 2:58 am

For example, I look up Product code as well as Country code from two instances of a table using one Lookup Stage.

Now suppose Product code finds a match and Country code does not, will it pass the matching record?