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 |
Solucionado! Ir para Solução.
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!
@Bren_Spill thank you!! that was quick...