Exchange rate

[qlikserbian]

Hi all.

i need your help? How to make link between 2 tables/

1 of them is sell out and 2nd one is table with exchange rate

sell out:

column 1

column 2

Datum

..

exchange rate:

Year	Month	Echange rate
2016	June	121,3

Can anyone help me little beat how to connect these two tables?

Please put picture, I use PE Qlik.

Thank you in advance,

[sunny_talwar]

May be like this:

Sellout Table

MonthName(Datum) as MonthYear

Exchange Rate Table

MonthName(Date#(Year & '-' & Month, 'YYYY-MMMM')) as MonthYear