Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
after loading the two tables
you can use this
intervalmatch (Date) load From_date,To_date resident Case;
after loading the two tables
you can use this
intervalmatch (Date) load From_date,To_date resident Case;