How do I get Alteryx to pick the correct currency ExRate based on date?

Question

Hello Alteryx Community!

This is my first thread as I could not find an answer within previous open topics.

I need Alteryx to bring back the correct Ex Rate conversion based on the date and the document currency. I am attaching the excel file we get from the government with the rates.

Can anyone please help?

Best regards,
Manoela

eurofxref-hist.csv

echuong1 · Accepted Answer

You can use a transform to pivot the data, so you have a listing of date-currency pairs along with the conversion value.

From there, you can use a join on the date and currency fields.