DSXchange

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.

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.

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.

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.

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

Please try it out before posting.