Input text format

[Devika]

Hello,

Please find the input file attached, the issue that i have is for column R and S .

The data in R and S column is captured in alteryx is not in the same format as in input file.

For example:-

In input file the value is 1.5000% but in alteryx it is captured as 1.4999999999999999E-2.

Also attaching the result that I get in alteryx. 

[LouisJ]

Looks like some type of float missinterpretation. There can be only one type per column (not per cell), and you have so many different types per column that Alteryx just defaults everything to string. Once you've sorted out your columns, just change the type to float or double, and if it's still 1.4999999999E-2 use a 'round([column],0.001)'.

[messi007]

@Devika,

Please se below :

I used tonumber and changed the output format to fixed decimal.

Attached the workflow,

Hope this helps!

Regards,