topic Why Left join in interval Match in QlikView

Why Left join in interval Match

Prabhu1204 — Sat, 16 Nov 2024 01:26:56 GMT

left join(Data)

IntervalMatch([ Date])

load StartDate,
EndDate

resident Data;

left join (Date)

load *

resident Data;

This code work But i wanted to know Why we use 2 left join ? I searched Qlikview community and implemented this.

Without left join my codes doesnt work..

Re: Why Left join in interval Match

Stoyan_Terziev — Wed, 22 Jan 2020 08:36:43 GMT

Hey, Prabhul,

What the interval match function does is it creates a new column in the table where the time ranges exist. That column contains the values found in the counter table with the exact 'dates'.

The left join combines the two tables in one. If you do not join the data, you need to make sure you have the columns properly named, otherwise you may trigger unwanted synthetic keys or auto-concatenation.

Ex:

Re: Why Left join in interval Match

Prabhu1204 — Wed, 22 Jan 2020 08:54:10 GMT

Thanks for clarifying

Re: Why Left join in interval Match

Brett_Bleess — Wed, 19 Feb 2020 16:59:10 GMT

Just adding a Design Blog post on IntervalMatch too, might provide a little further explanation on things for you:

https://community.qlik.com/t5/Qlik-Design-Blog/IntervalMatch/ba-p/1464547

Regards,
Brett