Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Free Trial

Alteryx Designer Desktop Discussions

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

Convert from Scientific Notation (E) to String Value

RMojsiak
8 - Asteroid

Hello,

 

I am trying to convert some numbers from the screenshot below to string. I tried to add a letter in front of the number and then trim it, didn't work. Also, I tried to use ToNumber but it takes out the numbers from other rows where I have combinations of digits, letters and sometimes special characters. I cannot put the data type to be fixed decimal because I also have some other instances where it looks something like 1234_abcd_123 (up until 15 digits).

I modified with the help of Select Tool to any type of string (and forced), with no luck.

 

RMojsiak_0-1631687832266.png

Thanks in advance!

1 REPLY 1
mst3k
11 - Bolide

i assume the field is a text datatype then, if you have these "1234_abcd_123" values?

you should be able to do something like what's attached by parsing out the number and the exponent and then doing simple math functions. you'll have to modify the formula to work for these other strange values you have, to parse out whatever number it's supposed to be

 

mst3k_0-1631692188647.png

so, what's interesting here is that the "final_number" wound up being -9852160 despite the original being -9852060. there may be floating point number issues coming into play in this kind of setup?

Labels
Top Solution Authors