Remove Scientific Notation from Long Numbers

Question

Dear all,

I'm inputting data from an Oracle database and several of the fields contains a long number (always 17 digits).  Alteryx is applying scientific notation to them which I can't find a way to convert from to create regular numbers.

I've tried the select and multi-field formula tools to no avail.

The closet I've gotten is the first 15 digits and then it just shows the last two digits as 00.  I believe this is something to do with floating points but don't know how to remedy it.

Any ideas as to what I may try?

Thank you,

DHB.

gabrielvilella · Answer

Hi @DHB, you just need a Select tool to change the data type of those fields to Double.

DataNath · Answer

Hey @DHB, this usually happens when the fields are brought in as string values. Does wrapping the fields in ToNumber() remedy this?

ToNumber([<Insert field>])

Failing that, converting the fields to a fixed decimal type may help, will just need to play around with the level of detail.