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: 
zagzebski
Creator
Creator

Interval Match Problem

I have tried looking at all the discussions on this site but still can't get what I want! I keep getting results different that what I exopect and with a sythnetic table. Seems basic all I want is ONE table with the following results...

EntityServiceDateOwnership_PctEffective_YearMthExpiration_YearMth
DEAN2009010.2200801999912
DEAN2007010.1200701200712
DNON2010010.6200901999912

LOAD * INLINE [
Entity, Effective_YearMth, Expiration_YearMth, Ownership_Pct
DEAN, 200701, 200712,  0.10
DEAN, 200801, 999912,  0.20
DNON, 200001, 200812,  0.50
DNON, 200901, 999912,  0.60
]
;

FACT:
Load * Inline [
Entity, ServiceDate
DEAN, 200901
DEAN, 200701
DNON, 201001]
;

Left Join(FACT)
IntervalMatch([ServiceDate],Entity)

Load
Effective_YearMth,
Expiration_YearMth,
Entity
Resident OWNER_DEF;

11 Replies
hic
Former Employee
Former Employee

Yes. Change the last Join to

Right Join (OWNER_DEF)
Load * Resident FACT;

zagzebski
Creator
Creator
Author

It works perfect! Thanks so much for sticking with me on this.