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

[hegdepavithra10]

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?

[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,

[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.

[hegdepavithra10]

Hi,

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

And the other excel file has the below one

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]

Hi @hegdepavithra10 

Here is a workflow for the task.

Output:

Workflow:

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

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

Hope this helps 🙂

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

[hegdepavithra10]

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

[atcodedog05]

Hi @hegdepavithra10 

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

[anjaliaithal]

Bring Both formats to same format Join and compare using Filter