Can alteryx read currency cell formatting from excel?

Question

My input data has numbers in it, which are manually formatted in excel to show the currency symbol next to them. The default behavior of Alteryx as far as I know is to read the plain data from each cell, ignoring any formatting. So in the process, while alteryx does read in the value and recognizes it as a number, I'm losing the currency symbol.

My question is, is there a way to read in the currency symbol as well which is the result of excel's built-in currency cell formatting, or is my only choice to add a separate currency column in my input data?

ArtApa · Answer

Hi @AkisM - If you want the amount to remain a numeric data type, you need to add a separate column with a currency symbol. However, if you want to read the symbol from your excel file there is a way you can achieve it. You can use a Run Command tool that will save your Excel file as a csv file and then you can read the csv, which will give you a string value with a currency symbol.

binu_acs · Answer

@AkisM you should add the currency symbol separate in your data, I also think Alteryx read the excel data as plain and ignores any formatting.