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!