Scientific(E) notation

Ankita1991

Hi All,

I have a data in excel where some records are in number format and some records are in percentage.When I have loaded that excel in Alteryx using Input tool ,percentage records are coming in Scientific(E) Notation.How should I convert to percentage?

Requirement:

I have to transpose all HQ1 till HQ5 columns,so I need a method to change the formatting of records having percentage format.Is there any method to do this or changing the formatting for only some records?

Please find attached screenshot of the data.

Any help will be highly appreciated.

Thanks

Ankita

Workflow

Developer Tools

Accepted answers

PedrodeOl

Hello @Ankita1991

In Excel, a percentage is a double divided by 100, when the file is loaded into Alteryx, it reads the file as a double, which is the reason for the scientific notation. If I understood your need, the attached workflow could solve it.

Let me know if it works

Convert_%.yxzp

All comments

DavidP

Hi @Ankita1991

I would use the Multi-Field tool to remove 1000 separator and % and convert the relevant fields to numeric fields. Then you can Transpose. Example attached.

convert multiple fields to number and transpose.yxmd

Ankita1991

Thanks @DavidP .I tried the same thing but in my case,percentage value gets converted to Number format.I guess ,it's because data is in different format in excel file and in the attached alteryx package,text input is used to enter data.

Attaching the dummy data file for your reference.

Test.xlsx

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703