I'm trying to do an IntervalMatch (or set analysis alternative) to be able to determine a headcount for any given date. A sample qvw is attached.
On any given date, I should be able to get a count of DISTINCT EmpKey for any combination of Dept and Status. It kind of works with IntervalMatch, but it will be messy when I try to scale it up to 50k employees.
tough case... sorry, haven't seen your question before... I assume you found one solution or another by now.
I'd consider concatenating Activities and Locations into a single table (with the same names for StartDate and EndDate fields) and differentiating between the two types of data using flags. This way, you only need a single INTERVALMATCH, and the whole picture might become a bit less ugly...
