How to display data from a date field between two dates in a large dataset with multiple sources.

[MColeman1999]

I have a large data set with multiple sources pulling data in and an employee table with start and stop dates as well as the current business title for those dates. I am using interval match to bring back data when employees are a certain business title. I now have a another table with just employee id's start and stop dates and what type of trying the employees are in. How can I integrate this table into the rest of the data to do the same as with the business titles? Can I do another interval match? See Below for Data model view

[Aasir]

Load your second table and link it like below
CONCATENATE (LINKTABLE)
LOAD
EmployeeID,
[Other Fields],
EmployeeType
RESIDENT EmployeeTypes_IntervalMatch;

Finally Reload data
STORE LINKTABLE INTO [YourExistingDataQVD.qvd];