Input Data tool - Alteryx changes and adds numbers to a string field

[Scarbrain]

I have the input file which I run monthly, for some reason Alteryx is changing the digits in the Oracle ID column, it appears to want to round out to 10 digits after the decimal. The oracle ID should be 8 digits after the decimal, not 10, and the 0s will drop off at the end, which is fine, I can add them in later...just unsure where these additional digits are coming from?

Examples attached

INPUT FILE DATA	ALTERYX
Region	Oracle ID	Date	Oracle ID
APAC	9082113.17001038	25/01/2024	9082113.1700103804
APAC	9082113.17048443	31/01/2024	9082113.1704844292
APAC	9082113.17080368	31/01/2024	9082113.1708036792
APAC	9082113.17009388	31/01/2024	9082113.1700938791
APAC	9082113.17080368	31/01/2024	9082113.1708036792
APAC	9082113.17002400	31/01/2024	9082113.1700240001
APAC	9082113.17080368	31/01/2024	9082113.1708036792
APAC	9082113.17084315	31/01/2024	9082113.1708431505
APAC	9082113.17084315	19/02/2024	9082113.1708431505
APAC	9082113.17008870	31/01/2024	9082113.1700886991

[Bren_Spill · Accepted solution]

Hi @Scarbrain - you can add a Select tool and change the data type to FixedDecimal 19.8 - see output below using this method. If this works for you please accept as solution, thanks!

 

[Scarbrain]

@Bren_Spill  thank you!! that was quick...