Skip to Content
0
Former Member
Jan 18, 2012 at 05:12 AM

Accessing two lookups

102 Views

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