Hi Experts,

I have a problem with Replace null value :- If field value is null Step

My source is a delimetd file( comma seperated ) .And I have some column value as null ( empty string )
Example:-

Col_1,Col_2,Col_3
1,name1,addr1
2,name2,addr2
,name3,addr3
,name4,addr4
3,name5,addr5

Note:- some of my col_1 value is null.

And I am loading this file to my target table.
In between I am using Replace Null value ( for Col_1 --> 0 )
But this is not working .

I tried with REPLACE STRING by giving an empty string in quotes ('')
also i tried with out entering any thing in the search option.

If i load the entire data into a temp table
make this as a source ,
use Replace null step
then target table step ; It will work.


Am I missing anything ?

Thanks in advance

AMR