Why Left join in interval Match

[Prabhu1204]

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.. 

[Stoyan_Terziev · Accepted solution]

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:

[Prabhu1204]

Thanks for clarifying

[Brett_Bleess]

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