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

E-Notation to Numeric conversion (Output)

Sasthana25
8 - Asteroid

Hi, 

 

I have build a workflow where I am getting the no. generated in exponential format when I output(export it)- refer below table please:

ABC29679193061-30538883530
YUO2.42422E+11-2.4874E+11
NHG9876928070-9745391035
DFK5.70141E+11-5.57734E+11
2 Day ccy8.52119E+11-8.46758E+11
   
Total1.26125E+12-1.26084E+12

 

Currently all the attributes for this calculation is in doubles - how can i get it into proper numeric format like below.

ABC29679193060.66-30538883529.53
YUO242421917966.75-248740210484.65
NHG9876928069.72-9745391034.73
DFK570140627445.62-557733924003.99
2 Day ccy852118666542.74-846758409052.90
   
Total1261249138616.64-1260835136254.78

 

Any help is much appreciated. 

 

Thanks,
Swati

 

 

3 REPLIES 3
DawnDuong
13 - Pulsar
13 - Pulsar

hi @Sasthana25 

One way is to use the ToNumber function

E.g. 

ToNumber("4.256411411E9") returns the string 4256411411 as a number.

ToNumber.PNG

 

For full details see this link: https://help.alteryx.com/20213/designer/conversion-functions

 

Dawn.

Sasthana25
8 - Asteroid

Thank you so much @DawnDuong. I have tried to use the same as suggest however, when its exported by output to .xlsx I am still getting the values in E-notation.

 

Similarly, I have few logics with percentage calculation, which is again coming in E-notation:

 

ABC
% 4 day ccy4.10E-023.94E-02

 

B and C needs to be in % - Is there a way to handle these and also get % symbol? 

 

Thanks,
Swati

DawnDuong
13 - Pulsar
13 - Pulsar

hi @Sasthana25 

as long as before you export to excel the numbers are converted to proper numbers then Excel will read them as numeric.

The reason why when viewed excel, the data appears as scientific format can be because of Excel auto formatting, not because of Alteryx. You can check this by clicking on the Excel field and see whether the data is a number or a text string. If it is already in numeric format, it's a matter of excel formatting.

If you want the output to have fixed format, one method is to use the Reporting Tool. I am not an expert in Reporting Tool though... 

If you want your format to be fixed in % and presented as a string, one way is to use the tostring function (https://help.alteryx.com/designer-cloud/conversion-functions )

 

Col%.PNG

 

hope this helps you.
Dawn.

Labels