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

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

hegdepavithra10
9 - Comet

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?

 

 

16 REPLIES 16
hegdepavithra10
9 - Comet

@atcodedog05  Could you help with this problem?

atcodedog05
22 - Nova
22 - Nova

Hi @hegdepavithra10 

 

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

messi007
15 - Aurora
15 - Aurora

dear @hegdepavithra10,

 

have you tried to use Fixed Decimal

messi007_0-1605353723855.png

Attached the workflow,

 

Hope that helps

 

Regards,

StephaneP
Alteryx
Alteryx

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%).

StephaneP_0-1605396231519.png

StephaneP_1-1605396261327.png

 

Then you have the 3 options 🙂

Hope it helps.

Stéphane Portier
Sales Engineer
Alteryx
hegdepavithra10
9 - Comet

Hi,

 

Lets assume, one of the excel has the below values.

 

hegdepavithra10_0-1605423561505.png

And the other excel file has the below one

 

hegdepavithra10_1-1605423611812.png

Once imported on to alteryx how would you compare them? Since they are in different formats.

 

My requirement is 

1. To retain the percentage format for column 1

2. To convert column 2 to percentage format

3. Both the fields to be compared

 

atcodedog05
22 - Nova
22 - Nova

Hi @hegdepavithra10 

 

Here is a workflow for the task.

Output:

atcodedog05_0-1605424466653.png

Workflow:

atcodedog05_1-1605424479772.png

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

 

In Tostring() function below highlighted 4 is specifying how many decimals to maintain

atcodedog05_2-1605424524337.png

 

Hope this helps 🙂


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

hegdepavithra10
9 - Comet

Is it possible to have both the columns as percentage format on alteryx?

atcodedog05
22 - Nova
22 - Nova

Hi @hegdepavithra10 

 

I saw you requirement and have updated my previous solution post please check.

anjaliaithal
7 - Meteor

Bring Both formats to same format Join and compare using Filter

Labels