This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
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?
@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?
@vizAlter - My column in excel has £ and EUR both in same column hence I can't have just one currency by using Filter tool. I would like to bring in the data as it is, so that I can convert EUR to £ and have everything as £ in one column. Below is the column in my .xlm file, for eg.: