Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

Alteryx Designer Desktop Discussions

Find answers, ask questions, and share expertise about Alteryx Designer Desktop and Intelligence Suite.
SOLVED

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

Jean_F
6 - Meteoroid

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

3 REPLIES 3
JohnJPS
15 - Aurora

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
6 - Meteoroid

Hi John,

 

That works! Thanks for your help !

elyinmartinez
5 - Atom
Thanks for your help
Labels