what is the main difference between the keep and j... - Qlik Community

Report Inappropriate Content · ‎2015-02-08

what is the main difference between the keep and joins

marcus_sommer · ‎2015-02-08

Joins are merging two/several tables into one single table - by keep all tables remain within the datamodel:

- Marcus

maxgro · ‎2015-02-08

here my answer, same question

Gabriel · ‎2015-02-08

Hi,

The main difference between KEEP & JOIN is, when you use KEEP your final table is 2 but when you use JOIN your final table is 1.

KEEP :- The keep prefix between two tables, has the effect of reducing one or both table(s) based on intersection, the two tables are not join.

JOIN :- The join prefix joins the loaded table with an existing named table or the last previously created.

Hope this help

Best Regards