Join two qvd-files in the data load

[LeneCecilie]

Hi, 

I have two qvd-files: Time.qvd and Case.qvd:

Time.qvd consists of: Date, Year
Case.dvd consists of: From_Date, To_Date, Case_NO and Amount

If I would write SQL I would do it like this:

Select

a.Date
b.Case_NO
b.Amount
From Time a Inner Join Case b on (a.Date between b.From_date and b.To_date) 

How do I do the same thing in Qlik Sense Data Load Editor?

[lironbaram · Accepted solution]

after loading the two tables 

you can use this 

intervalmatch (Date) load From_date,To_date resident Case;