Skip to main content

Qlik

cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Karthik3
Creator III
Creator III
‎2017-05-23 06:42 AM

Joining Tables based on Start date and End dates and a data field?

Hi,

    I am trying to build a data model with 10 tables approx which all have a start date and end date and a personnel number as common fields. It is SAP HR data. Personnel number is common field to join all tables but start date and end date are also important. I know about Interval match. What is the best way of joining these tables? Can we do an interval match between two date fields?

Regards,

Karthik

458 Views
0 Likes
2 Replies
ahaahaaha
Partner - Master
Partner - Master
‎2017-05-23 08:06 AM

Hi Karthik,


You can start from here Matching intervals to discrete data ‒ QlikView‌


Regards,

Andrey

377 Views
0 Likes
santiago_respane
Specialist
Specialist
‎2017-05-23 08:33 AM

Hi Karthik, you can use extended interval match to achieve that. This is used when you have some more keys (apart from just StartDate/EndDate ) to be matched.

Maybe this helps.

Kind regards,

377 Views
0 Likes