Convertion from character to numeric, with 15 to 20 decimal values

Question

Dear All,

I need to convert a character value in numeric. The values to convert get more around 20 decimals so I tried in several ways:

- using the Auto Field tool

- using the "ToNumber" function, in a Formula tool

- applying a FixedDecimal format, with the right number of decimals

With Auto field, the converted value is a Double, with a round done at the 6th decimal. With the 2 other ways, a random (?) round is done.

Exemple :

initial value: 0.000733521953264 > converted value: 0.00073352195326399996

initial value: 0.000257864878804> converted value: 0.00025786487880400001

Any help is wellcome !!! And sorry for my basic question, I'm quite new using Alteryx

Jean

JohnJPS · Accepted Answer

Hi @Jean_F

In order for me to get it in full Fixed Decimal glory, I had to first force Alteryx to read it as character data.  One way to do this is to add a dummy first row that literally contains various characters.  From there, Alteryx has a precision of 50 for fixed decimal, but doesn't seem to like something like 25.25... but 26.24 worked for me.  (See attached.)

Jean_F · Accepted Answer

Hi John,

That works! Thanks for your help !