Issue with converting to number

[Bill9]

Hello,

I cannot convert the V_WString format data to number with 2 decimal places for the text format data which is downloaded from SAP.

e,g. data 4,134.34 in text file to number format as 4134,34. I do not know why the converted result as 4 with my file. 

Please find the attached original text format file and Alteryx convert file with error.

Thanks a lot in advance!

[JosephSerpis · Accepted solution]

Hi @Bill9 you need to remove the , in the data and then it will convert to a numeric data type without issue.

[Bill9]

Dear Joseph,

Perfect! thanks a lot!

Br/Bill