Alteryx adding Decimal and zeros after last number

[dheerajasia]

When I import data from my CSV file, Alteryx is adding decimal and zeros to the data and the output.

Original:

Alteryx Output:

I tried various datatypes in the Select tool before generating the output but that doesn't seem to wrok.

[gautiergodard]

@dheerajasia Would you be able to share the workflow or inputs you are working with?

[marcusblackhill]

Hi @dheerajasia !

I'm not sure if I got correctly the issue, so correct me if I'm wrong here. You used one CSV file as input (that one don't have decimals), but when you output your data from Alteryx to CSV that add these decimals, is that?

If it is the case, you tried to use the int64 as data type for your fields? Or even force as a string?

In case the issue is not the output from Alteryx, is the decimals in the workflow itself, I believe you don't need to worry so much since that is not going to your output. If you need to remove those decimals, and it is already a numeric field, you could also add the formula tool with the round formula, if the data type change is not being enough to fix it for you.

[dheerajasia]

I used CSV file as input and it has no decimals. But they appear as Decimals in the data window after importing.

Once I do my data manipulations and try to save it in .xlsx, they are being saved with the decimals as shown in the screenshot. I forced them to int64 and string and all other combinations but nothing seems to stop this decimal generation in the output file.

I am seeing these errors when I use int64 in Select tool Datatype.

[marcusblackhill]

Those warnings are because Alteryx is not understanding the 0s as zero, instead is understanding them as a really small number like 0.00000000001, so it is warning you about what you're losing. Add a formula tool rounding the values before the select tool and see if that fix it to you.

To use the round, you can write the formula round([your_field_here],1)