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