How to normalise two different formats for same value from Excel in alteryx

Hi,

I have a value from two different Excel sheets and different format. From one excel sheet the value is 0.1410% and the other is 0.0014101. These are same values in different format . One is number other is percentage. I want to import these values to alteryx and compare these values to check if they are same. But I am having trouble because of the formats. And the values in alteryx show up as exponential values. I did try to convert them into double using select tool, but it doesn't help. Could someone help in normalising these formats?

Data Investigation

Accepted answers

hegdepavithra10

Hi,

But when i import the percentage value to Alteryx. It shows up as an exponential value, the first value from column 1 is 1.41E-3 on alteryx

atcodedog05

Hi @hegdepavithra10

You can try

ToNumber([Column 1])

It should work.

End formula should be something like this

ToString(ToNumber([Column 1])*100, 4)+"%"

Hope this helps 🙂

If this post helps you please mark it as solution. And give a like if you dont mind 😀👍

decimal.yxmd

All comments

hegdepavithra10

@atcodedog05 Could you help with this problem?

atcodedog05

Hi @hegdepavithra10

Can you share a sample files so that i can look into it.

messi007

dear @hegdepavithra10,

have you tried to use Fixed Decimal

Attached the workflow,

Hope that helps

Regards,

Convert.yxzp

StephaneP

Hello,

In complement of @messi007 examples I have added a 3rd one in case your source is stored or interpret as a text (0.141%).

Then you have the 3 options 🙂

Hope it helps.

ConvertV2.yxzp

Quick Links

This months top contributors

atcodedog05 19458

Qiu 15866

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703