topic JOIN() AND KEEP() FUNCTIONS in QlikView

JOIN() AND KEEP() FUNCTIONS

Wed, 19 Feb 2014 11:25:28 GMT

what is the difference between JOIN() and KEEP() functions and also similarities of the those functions in qlikview

Re: JOIN() AND KEEP() FUNCTIONS

Wed, 19 Feb 2014 11:26:29 GMT

The keep prefix is similar to the Join prefix. Just as the join prefix, it compares the loaded table with an existing named table or the last previously created data table.

But instead of joining the loaded table with an existing table, it has the effect of reducing one or both of the two tables before they are stored in QlikView, based on the intersection of table data. The comparison made is equivalent to a natural join made over all the common fields, i.e. the same way as in a corresponding join. However, the two tables are not joined and will be kept in QlikView as two separately named tables.

Note!
The explicit Join prefix in QlikView script language performs a full join of the two tables. The result is one table. In many cases such 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.

Re: JOIN() AND KEEP() FUNCTIONS

vikasmahajan — Wed, 19 Feb 2014 11:28:18 GMT

Document by Mr.Henric

Vikas

Re: JOIN() AND KEEP() FUNCTIONS

Siva_Sankar — Wed, 19 Feb 2014 11:28:46 GMT

Subbu,

You can get a deep understanding with examples and differences between Joins and Keep Functions here

http://community.qlik.com/thread/39177

Regards.

Siva

Re: JOIN() AND KEEP() FUNCTIONS

IAMDV — Wed, 19 Feb 2014 12:12:46 GMT

Subbu,

I've made video tutorials on Joins. Please check the below links...

http://qlikshare.com/877

http://qlikshare.com/898

Thanks,