Hi,
I have a source file and two lookups and based on a condition in source file, i have to access both the lookups and retrieve values. Is it possible to call two lookups simultaneously?
The work flow is like this:
If Source.ColA=0 and lookup1.Col1 = '1', then output value from lookup2.Col2 into target output
If Source.ColA=0 and lookup1.Col1 = '0', then output value from lookup2.Col3 into target output.
I could call only one lookup at a time using lookup_ext function. Is there any other option of doing this?
Appreciate your help.
Thanks,
Arun