JSON Input Rounding Decimal

Question

Hello,

I am using the Input Data tool to input data from a JSON formatted file (see attached zip file).  Configuration has File Format set to JSON (*.json), Parse Value as String is checked, Code Page is Unicode UTF-8

My sample json file shows the InitialRate value of 0.01234567891234567

However when I input the data, it comes in as 1.23456789123457e-02

Not only is it showing in scientific notation but it's rounding the last 6 to a 7 and dropping the 7.

Is there a way to input this json data and have InitialRate data unchanged?

Appreciate any support!

sample 20241022.zip

bertal34 · Answer

@nagakavyasri   thanks for your reply but that is not going to work.  The requirement is to input the exact decimal number as it is in the json file.  0.01234567891234567

nagakavyasri · Answer

Converting the values from scientific Notation would be one solution.

https://knowledge.alteryx.com/index/s/article/Converting-Values-from-Scientific-E-Notation-1583460176754

Since 17 decimal digits to the right are only allowed, the last digit is rounding off to 7.