Matching data

[martavertone]

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

[ZacharyM]

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

[ZacharyM · Accepted solution]

@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