Alteryx automatically converts string (£45.50) to number (45.50) while importing file?

Hello people!

I am importing a .xlm file that has value column with currency eg. £45.50 or 56.70 EUR. When I import this file using Input Tool, Alteryx automatically converts these values into numbers and removes the £ sign and EUR. I would like to keep it as is and don't want it Alteryx to convert values to numbers because I need to see which values are £ and which are EUR. Can someone please help with this query?

Thanks in advance!

Datasets

Best Practices

Dynamic Processing

Preparation

Optimization

Accepted answers

vizAlter

@anks_joi — Try this solution..., hope it will be helpful, if not let me know.

In Formula tool:

"&pound; "+ REGEX_Replace([Value Retail Loss], "([^0-9,.-])", "")

Please mark it "Solved" or "Solved" with a Like if it resolved your query. This will help other users find the same answer/resolution. Thank you.

Currency Sign correction_v1.yxmd

Currency Sign correction_v1.yxzp

All comments

vizAlter

Hi @anks_joi — Can you attach sample data?

(Looks that digits are not in String data type in your input file.)

anks_joi

@vizAlter - Thank you for your response. Unfortunately I can't attach data as it is confidential client data. I think you are right, the digits are not in string data type it is "Custom". I have 52 such excel files with half a million rows of data in each file. Is there a way I can convert the number to string in Alteryx and still have £ and EUR in the column?

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703