what is the main difference between the keep and joins

[#1]

what is the main difference between the keep and joins

[marcus_sommer]

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

http://community.qlik.com/search.jspa?q=join+vs.+keep

- Marcus

[maxgro]

here my answer, same question

http://community.qlik.com/message/583535#583535

[Gabriel]

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