Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
when should we use left join in Qlikview?
Howdy Vsharma1,
When do you need to breathe? When do you need to drink? When do you need to answer vague questions with vague answers:
When you need to! 😄
This is almost impossible to answer through texts. Here is a great video by Abhishek that better describe their use:
https://www.youtube.com/watch?v=T_NZY1I2-zU
Hope that helps!
Kind regards,
Yogi Achilleos
are we using join just to make data model simpler?
It would be possible to use it to make the data model more efficient, hopefully that puts things into a better perspective, as if you have two tables that have the same number of rows with a delta of only a few columns, then it is going to likely be much more efficient to use a JOIN to make the two tables a single table... Hopefully this helps a bit more.
Regards,
Brett
Ok, Thank you