Work Flow Help - Currency Conversion

[kmontoya]

Hello! 

I have a file that has profit & loss in different currencies (see original data tab). Is there a way that Alteryx can convert each amount in USD. I would like it to look like "how we want the data" tab. 

Thank you in advance! 

[cjaneczko · Accepted solution]

Take a look at this article. It is likely going to require an API as currencies constantly fluctuate. 

https://knowledge.alteryx.com/index/s/article/Everything-You-Need-to-Know-About-Currency-15834601845...

[apathetichell · Accepted solution]

My expectation is that your company has a standard currency table (whether in a DB or an ERP) which is used for your calculations. You should identify which source is used for this table - and then build a join vs your currency table and this excel file. If you need to access this from say an ERP  - you may need to use an API as @cjaneczko - pointed out. If you are using a DB - you may need a query to bring it in. This is all very company speciifc.

[caltang]

Yup, as the other two said - this depends on how your company organizes the currency rates of the date. Even a small decimal place off can impact your P&L significantly, so thread carefully on this.