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
Solved! Go to Solution.
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.)
Hi John,
That works! Thanks for your help !