Excel currency format data loading

[zlhiano]

I have an excel file where it has a column formatted as currency, so it appears in excel as EUR 8 but the cell itself is actually 8. When I loaded it to Alteryx, the currency information is gone. Anybody has any idea how to load the currency format as well? Thank you! I've attached a sample of my data.

[danilang · Accepted solution]

Hi @zlhiano 

The problem here is that the format specifier for Currency in Excel has a drop down that allows you to pick a different Currency for each cell.  This isn't stored in the cell, but in the format specifier, which isn't something that Alteryx reads.  

The good news is that if you save your file as CSV, Excel writes out the Currency as well as the date, so your file looks like this

Name,Origin,AUM
ab,UNITED KINGDOM,USD 6.80
ef,AUSTRALIA,AUD 184.70
gf,SWITZERLAND,EUR 73.00
dds,CANADA,USD 323.00
sa,FRANCE,EUR 8.30

which is relatively easy to parse.  

If you can't save the file as CSV yourself, this post contains the basics of how to trigger a VBS script from Alteryx.   What you would do is set up the script to save the file as CSV and then open the CSV.

Dan 
 

[zlhiano]

Amazing! Thanks a lot!