Keep & Join

[#1]

Hi,

I have read at multiple places about keep and join functionality in qlikview.

They work exactly the same, except join prefix joins two table into one. My question is so when we should use keep and when we must use join.

Thanks in Advance

Regards

Priyanka

[Chanty4u]

Hi Priyanka,

Please follow the below link.

https://community.qlik.com/message/703842#703842

hope this clears your doubts

Thanks

Suresh Chanty

[hic]

A general rule is that you should join as little as possible. See To Join or not to Join.

You should look at "Keep" as an alternative to using "where Exists()".

HIC

[Anonymous]

hi priyanka,

please see below post:

Re: Left Keep Vs Left Join