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

[IguanaVerde]

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

[echuong1 · Accepted solution]

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.

[IguanaVerde]

Thank you! Completely forgot about that!