Skip to main content

I have unconnected lookup lkp_tst with the below ports - x,y,z x,y,z - all these 3 fields are strings. This unconnected lookup port has x as the return port Also added i/p port (ipp) - to define the lookup cond Cond: x=ipp Writtern sql

Cond: x=ipp

Written SQL override query in lookup transf. as

select x+''+y+''+z as x from test

select x+''+y+''+z as x from test

the test table is created in SQL server DB

From the expr. transf.expr. transf. - am calling the unconnected lkp :lkp.lkp_tst('abc') Now

:lkp.lkp_tst('abc')

Now when iI try to try to debug it - it always returnreturns

But however when i dontI don't override the query in lkp transformation - iI see the x been returned. My objective is to return the concatenateed value from unconnected lookup. Please advise.

My objective is to return the concatenated value from the unconnected lookup. Please advise.

I have unconnected lookup lkp_tst with the below ports - x,y,z - all these 3 fields are strings. This unconnected lookup port has x as the return port Also added i/p port (ipp) - to define the lookup cond Cond: x=ipp Writtern sql override query in lookup transf. as

select x+''+y+''+z as x from test

test table is created in SQL server DB

From the expr. transf. - am calling the unconnected lkp :lkp.lkp_tst('abc') Now when i try to try to debug it - it always return

But however when i dont override the query in lkp transformation - i see the x been returned. My objective is to return the concatenateed value from unconnected lookup. Please advise.

I have unconnected lookup lkp_tst with the below ports - x,y,z - all these 3 fields are strings. This unconnected lookup port has x as the return port Also added i/p port (ipp) - to define the lookup cond

Cond: x=ipp

Written SQL override query in lookup transf. as

select x+''+y+''+z as x from test

the test table is created in SQL server DB

From the expr. transf. - am calling the unconnected lkp

:lkp.lkp_tst('abc')

Now when I try to try to debug it - it always returns

But however when I don't override the query in lkp transformation - I see the x been returned.

My objective is to return the concatenated value from the unconnected lookup. Please advise.

Source Link

Unconnected lookup sql override issue

I have unconnected lookup lkp_tst with the below ports - x,y,z - all these 3 fields are strings. This unconnected lookup port has x as the return port Also added i/p port (ipp) - to define the lookup cond Cond: x=ipp Writtern sql override query in lookup transf. as

select x+''+y+''+z as x from test

test table is created in SQL server DB

From the expr. transf. - am calling the unconnected lkp :lkp.lkp_tst('abc') Now when i try to try to debug it - it always return

But however when i dont override the query in lkp transformation - i see the x been returned. My objective is to return the concatenateed value from unconnected lookup. Please advise.