Varchar to decimal -
Posted: Sat Mar 26, 2005 6:54 pm
I am reading several fields as varchar and in the first transformer I just choose the data type as decimal 15 and everything worked fine as expected. The max I had to do was in the transformer use
But for only one field I could not get away with this. I had to use handle_null in a modify stage.
Otherwise when I validate I get an error message something like
Wen converting form string to decimal , no null handling etc....
Any ideas??
Code: Select all
IF IsNull(filed) Then 0 Else filed
Otherwise when I validate I get an error message something like
Wen converting form string to decimal , no null handling etc....
Any ideas??