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

[atcodedog05]

Glad to hear 

Happy to help : )

Cheers and Happy Analyzing 

[atcodedog05]

.

[rachana19]

,.