multiple lookup

dnat · Post by **dnat** » Sun Dec 20, 2009 10:34 pm

HI,

I have two columns in the source that needs to be looked up to a single column in the reference. Can this be done in a single stage or we need to use multiple lookup stages.
Even if one of the lookups fail, i need that record in the reject link.

ray.wurlod · Post by **ray.wurlod** » Sun Dec 20, 2009 10:56 pm

Neither will work given your requirement. You need a Transformer stage upstream of the lookup stage to combine the two columns appropriately into one. Then perform the lookup using that one.

dnat · Post by **dnat** » Sun Dec 20, 2009 11:05 pm

Ray, i didnt get what you are trying to say

In the input i have col A(Value xxx) and col B(Val yyy)

In the reference stage i have two rows with the following values

Key--Val
1 -- xxx
2 --yyy

Now i want to lookup Col A with val xxx in reference and Col B with Val yyy in reference.

ray.wurlod · Post by **ray.wurlod** » Sun Dec 20, 2009 11:08 pm

OK, clearly I did not understand what you had in mind. I understood you had one row in the reference, value xxxyyy.

Your clarified requirement needs two separate lookups.

Sainath.Srinivasan · Post by **Sainath.Srinivasan** » Mon Dec 21, 2009 3:48 am

You need 2 lookups but can be done in single stage.

Please try it out before posting.