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.