DSXchange

Hi all,

I am trying to convert the source data type from Varchar to decimal and am using the Modify stage. I am getting this warning


When checking operator: When binding output interface field "column_nmae" to field "column_name": Implicit conversion from source type "ustring[max=10]" to result type "decimal[1,0]": Converting ustring to decimal.

Can you please suggest me how can i Handle this

Thanks
yar

Doesn't seem like you have the decimal portion set up correctly: result type "decimal[1,0]" won't hold the contents of a 10 character string, hence the message.

Hi Chulett,


Thanks for the reply, But I am Converting from varchar to decimal in the "Modify Stage" I am using the following Specification in Modify Stage


Column_Name:decimal = handle_null(Column_Name,0).

Please let me know if this Specification is correct.


Thanks
yar

If the input column is a string, then there is no implicit conversion to decimal. You need decimal_from_string() function.