46 Joining tables using keep in qlik sense

In this #QlikSense tutorial video I have talked about how you can use keep keyword to join two tables in qliksense. Keep is an interesting keyword and functionality which not only allows you to join two table but after joining it keeps two table seperate as well for any further data modeling with other tables.

#QlikSenseTutorial

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 Qlik Sense, 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 Qlik Sense as two separately named tables.

Syntax:

(inner | left | right) keep [(tablename ) ]( loadstatement | selectstatement )


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

The explicit join prefix in Qlik Sense 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 Qlik Sense 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 Qlik Sense scripts. The keep functionality was designed to reduce the number of cases where explicit joins needs to be used.

[prakashrao]

How many keeps in qlik sense bro..

Outer keep is not in qlik view