Decimal automatically transfer to string with unknown reason

Question

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!

LT.xlsx

gyang3 · Answer

@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!

grazitti_sapna · Answer

@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.

philosophy22 · Answer

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.