Qlik Community

QlikView Documents

Documents for QlikView related information.

Intervalmatch example – with dates

Arjunarao
Honored Contributor II

Intervalmatch example – with dates

I have two tables Table1,Table2. Table1 has DATE, Table2 has START_DT,END_DT. Want to join these two tables on DATE columns.

Intervalmatch function will help us to make the join in Qlik. If we use left join, we can avoid synthetic tables too. Here is the example.

If you want to test, prepare the test data.

Let me know if you need any more info/clarification.

Table1:

LOAD COUNTRY,

DATE,

C1,

C2

FROM Table1;

Table2:

LOAD COUNTRY, C3,C4,

date(START_DT) as START_DT,

date(END_DT) as END_DT

FROM Table2;

Final_Table:

INTERVALMATCH (DATE) left JOIN LOAD START_DT, END_DT RESIDENT Table2;

left Join (Table1) LOAD distinct * RESIDENT Table2;

DROP TABLE Table2;

Labels (3)
Comments
guy_hombleu
New Contributor III

Thanks for the example, works superb!

Arjunarao
Honored Contributor II

@guy_hombleu

Nice to hear. Please mark the correct Answer.

Version history
Revision #:
1 of 1
Last update:
‎03-06-2018 04:47 AM
Updated by: