Search value in table

[GdeH]

Hi, 

I would like to add the the currency exchange rate in Alteryx. 

For this, I have 1 table with 2 columns currency and a date and

and another table with the date in columns and the currencies in rows 

How can I add the currency exchange rate to my first table with currency and date? 

Thank you. 

[messi007]

@GdeH,

You have to use join in this case.

Could you share a sample of both files it will be help to provide you the solution.

Regards,