Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Interval Match?

Hi,
I have the following two tables:
Tab1:
load * inline
[StartDate, EndDate, EmpPeriod
10000, 20000, FirstYear
20001, 30000, SecondYear
30001, 40000, ThirdYear
]
;

Tab2:
load * inline
[SDate, EDate, EmpName
15000, 16000, Tony
22000, 29999, Mark
19999, 25000, John
32000, 39000, Ken
10023, 39997, Frank
]
;
The SDate and EDate would determine the EmpPeriod of EmpName. I tried Interval Match but maybe I am doing something wrong. I can do for either SDate or EDate between StartDate and EndDate, but how do I check if SDate AND EDate are between StartDate and EndDate?
The result should be:
EmpNameEmpPeriod
TonyFirstYear
MarkSecondYear
JohnFirstYear
JohnSecondYear
KenThirdYear
FrankFirstYear
FrankSecondYear
Frank
ThirdYear
10 Replies
Not applicable
Author

Thank u Sir.

Its perfect

gonna buy a new dictionary to learn some words bigger than Thank you....

was stuck wid this from the last 3 days...

Really happy