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

Text with "D" automatically converts to scientific "E"

Manojkumar
8 - Asteroid

Hi Team,

 

i am trying to pass the following text "15D213" from text input tool to a macro.

But it automaticall converts to 1.5E+ values. i want it to be passed as 15D213 to macro.

Can anyone please help

4 REPLIES 4
T_Willins
14 - Magnetar
14 - Magnetar

Hi @Manojkumar,

 

Since it is coming from a text input, can you add a leading character in the text input, then remove that character with a subsequent formula tool?

 

Keep string format.JPG

 

TonyA
Alteryx Alumni (Retired)

Hi @Manojkumar ,

You have run into a very weird idiosyncrasy of certain computer languages. In some languages, including C (which a good part of Designer is written in), "D" is used to indicate double precision scientific notation. Alteryx is interpreting numbers according to that rule. This won't be a problem if there are strings somewhere in the column, but if all the values are either numeric or are numbers with a single "D" or "E" then you'll need a workaround like the one suggested by @T_Willins . If you have multiple columns with the same issue, another option would be to add a dummy first row that forces the data type to strings for all the problem columns and then remove it with a sample tool as a first step in the workflow. 

Manojkumar
8 - Asteroid

Hi Willins,

 

Thanks for the solution !!

Manojkumar
8 - Asteroid

Hi Tony,

 

Thanks for clarifying the issue

Labels