topic Diff between keep and join in QlikView

Diff between keep and join

mastankomatla21 — Thu, 08 Feb 2018 11:05:03 GMT

Hi,

What is the difference between Join and keep?

when we go for keep and when we go for joins? explain in detail

Regards,

Masthanaiah.K

Re: Diff between keep and join

YoussefBelloum — Thu, 08 Feb 2018 11:19:41 GMT

Hi,

here is all the details you need

Understanding Join, Keep and Concatenate

Re: Diff between keep and join

avinashelite — Thu, 08 Feb 2018 11:22:09 GMT

their are lot of thread in the community google it ...

When Use Keep When Use Join

Difference between keep and joins with example

Re: Diff between keep and join

surendraj — Thu, 08 Feb 2018 11:23:21 GMT

With reference to Qlikview help!!

Join:It combines the two tables into single table based on the key column.(result as single table)

Keep: the two tables are not joined and will be kept in QlikView as two separately named tables.(Two Tables)

The keep prefix must be preceded by one of the prefixes inner, left or right.

When we go for keep:

In many cases joins will result in very large tables. One of the main features of QlikView is its ability to make associations between multiple tables instead of joining them, which greatly reduces memory usage, increases processing speed and offers enormous flexibility. Explicit joins should therefore generally be avoided in QlikView scripts. The keep functionality was designed to reduce the number of cases where explicit joins needs to be used.

Hope this helps you!!