Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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];