Catch a null in file & put spaces

jayantthakore · Post by **jayantthakore** » 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......??

Sunshine2323 · Post by **Sunshine2323** » 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.

RobertScarbrough · Post by **RobertScarbrough** » Fri May 13, 2005 11:51 am

Another method is shown below:

Code: Select all

NullToEmpty(lnkLookUp.ColumnA)