Decimal automatically transfer to string with unknown reason

[philosophy22]

Hi,

I am using this excel as input to do some calculation, the gearing proportion column has some decimals and normally alteryx will recognize this column with data type double. However, in this case, alteryx recognized it with string type, and if i transfer this type to fixed decimal, will cause some decimal data missing, can not understand why this happened, If anyone knows answer, please tell me the reason. Many thanks!

[grazitti_sapna]

@philosophy22  This is because your data contains exponential values as below and you need to cast them to number to change their datatype to fixed decimal using formula tool. Please find below the workflow for correct way of doing it.

[philosophy22]

Thank you for your reply. The exponential values is transferred by alteryx, not in my data. And if i directly transfer data type to fixed decimal, as the question mentioned, there were some data missing.

[grazitti_sapna]

@philosophy22 , yes the exponential values are getting missed because it has alphabet E in data, therefore Alteryx is unable to convert it to decimal directly and you will have to cast it to number and then change it to decimal data type. 

[gyang3]

@philosophy22 the workflow that @grazitti_sapna provided should do the trick in converting those exponential values into a numeric value. If you think you are still missing some data, you can increase the scale from 6 to 10 in the Formula tool which will expand the data 10 digits to the right of the decimal.

Hope that helps!