topic Re: Joining Tables based on Start date and End dates and a data field? in QlikView

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

Karthik3 — Wed, 25 Nov 2020 16:16:04 GMT

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

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

ahaahaaha — Tue, 23 May 2017 12:06:00 GMT

Hi Karthik,

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

Regards,

Andrey

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

santiago_respane — Tue, 23 May 2017 12:33:26 GMT

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,