NOT FOUND CONDITION
Posted: Fri May 28, 2004 6:11 am
Hi ,
I have a doubt regarding the NOTFOUND condition.
My job looks like
lukup(OLEDB)
|
|
V
FILE ----> Transformer -------> FILE
My requirement is if lukup found means populate the looked up valuee else populate input value
I gave the condiotion if link.NOTFOUND = 0 THEN lookedupvalue else input value
I'm not gettingthe desired result. i.e If the look up doesn't have matching value means it is populating spaces.If look up returns means it is populating the looked up value.
Am i missing anything here ? What should i do to get the input value in case of look up not neturning value.The same situation works fine with ODBC look up.
I have a doubt regarding the NOTFOUND condition.
My job looks like
lukup(OLEDB)
|
|
V
FILE ----> Transformer -------> FILE
My requirement is if lukup found means populate the looked up valuee else populate input value
I gave the condiotion if link.NOTFOUND = 0 THEN lookedupvalue else input value
I'm not gettingthe desired result. i.e If the look up doesn't have matching value means it is populating spaces.If look up returns means it is populating the looked up value.
Am i missing anything here ? What should i do to get the input value in case of look up not neturning value.The same situation works fine with ODBC look up.