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 )


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