Hello,
I would need some basic help to solve my problem..
I have an input files which reports a list of products with related price and currencies + the currency in which it has to be converted.
Product | Price | CCY | CCY to be converted into |
1 | 32,50 | EUR | SEK |
2 | 10.20 | USD | CAD |
3 | 5.25 | EUR | AUS |
4 | 8.30 | USD | EUR |
Then I have a separate mapping table where I have the exchange rates for each combination
From CCY | To CCY | ExRate |
EUR | SEK | 0.5236 |
USD | EUR | 1.302 |
How can I map back in my file the currencies so that I can created an additional column which reports the price converted in the To CCY ?
thank you in advance and kind regards
Marta
Solved! Go to Solution.
You'll want to input both of these tables of data as data inputs, then join them together on both the "CCY" and "CCY to be converted into" columns.
I will throw together an example in a moment.
Zak
@martavertone - See attached for a working example - I threw the data in Alteryx as text inputs, setup the joins, and then even used a formula tool to calculate the converted price.
Take a look and let me know if this is what you meant or if I missed the mark!
If this solves your issue, please mark this (or another response) as an accepted solution so people know you've been helped!
Best,
Zak