Skip to Content
avatar image
Former Member

Why "Data Lookup" has only 1 source column and 1 Target column?

I am not sure why we have this limitation? By design? How do we model a lookup similar to this?

select col1 as Target1, col2 as Traget2 from LookupTable where sourceCol1='?' and sourceCol2='?'

Than you very much for your help!

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Oct 23, 2015 at 04:10 AM

    What are you trying to do that 2 separate lookups (1 for each column) cannot accomplish?

    Chris

    Add comment
    10|10000 characters needed characters exceeded

    • Former Member

      Hi Chris,

      Thank you so much for your reply.

      Unfortunately logically they are NOT same. As you can see

      select col1 as Target1, col2 as Traget2 from LookupTable where sourceCol1='?' and sourceCol2='?'

      is different than

      1) select col1 as Target1 rom LookupTable where sourceCol1='?'

      2) select col2 as Traget2 from LookupTable where sourceCol2='?'

      since they where condition are different. The major issue is that we can not choose multiple "Source column" even if we can simulate multiple target column with multiple look up of a single Target column.