DSXchange

Posted: **Tue May 10, 2005 5:55 am**

Hii guys,
I am doing a lookup & replacing the new value on the key value(say column A) after the lookup..
If lookup fail it will insert NULL value in the place of column A....
There is a transformer after the lookup which has constraint
IsNull(column A) .
I want to catch those values which fail the lookup without having the reject link ....It should be caught in the transformer by the above constaint..
Can anyone help......??

Posted: **Tue May 10, 2005 6:23 am**

Hi,

In the LookUp set the property If Not Found - Continue

Then in the transformer you can check for the value of column A in the derivation as

If IsNull(lnkLookUp.ColumnA) Then " " Else lnkLookUp.ColumnA

Hope this helps.

Posted: **Fri May 13, 2005 11:51 am**

Another method is shown below:

Code: Select all

NullToEmpty(lnkLookUp.ColumnA)

DSXchange

Catch a null in file & put spaces

Catch a null in file & put spaces