Input data as percentage category in Excel

[rachana19]

Hi,

I am facing a challenge in Alteryx as explained below -

Sample input excel file

ID	Rate1	Rate2	Rate3
1	3.15%	0.85	15.00%
2	100%	0.38	0.875
3	0.54	6.50%	100%

However when I use the input tool to import the above data, it is read as below -

ID	Rate1	Rate2	Rate3
1	0.0315	0.85	0.15
2	1	0.38	0.875
3	0.54	0.065	1

So basically I lose the % symbol and alteryx automatically converts the values to numbers.

How can I retain the % symbol?

Thanks in advance

[fmvizcaino]

Hi @rachana19 ,

The only way of doing that is by transforming your number into a string with a %.

Workflow attached.

Best,

Fernando Vizcaino

[rachana19]

Dear Fernando,

Thanks a lot for your reply.

As you can see the input, some values in the same column are numbers while others are percentage. So if I convert the values back to %, it wont be correct for all the values.

Is there any way to retain the input in alteryx as it is?

Regards,

Rachana Varma

[Jonathan-Sherman]

Hi @rachana19,

Could you attach a sample file for which this is an issue?

Regards,

Jonathan

[rachana19]

Dear Jonathan,

Thanks a lot for your reply.

Unfortunately I cannot share the original data due to confidentiality, however I am sharing a sample file. 

Kindly suggest if we can retain the data as it is in Alteryx.

Regards,

Rachana 

[rachana19]

Hi All,

Could anyone please help in this regard?

[atcodedog05]

Hi @rachana19 ,

Your sample data doesnt have any similar data. Can you check and guide us on which sheet or repost  the data.

[rachana19]

Hi 

This is how I have the data in input file. Same column has some fields as general and some as percentage.

Please suggest.

[atcodedog05 · Accepted solution]

Hi @rachana19 ,

The issue you are facing is caused by excel and its data consideration.

One of the fix is changing the data types in excel. But i do know thats a tedious task.

A quick fix is save the sheet as .csv (csv considers all the data as string, which provides opportunity for manipulation)

Here is the workflow of manipulation. 

If the number has % then divide by 100 else no.

Change this to suit your requirement.

Hope this helps

[rachana19]

Thanks a lot for this possible solution. I will check with the person providing inputs, if we can convert to csv.

But this works great.