what is keep and join?explain differences

[#1]

hi everybody

can u explain the keep and join,and also explain the differences

[its_anandrjs]

Hi,

When using Join after joins (Left, Right, Inner, Outer) you get single table but after Keep join Jain is perform but you get second table also.

For more you can read here.

http://community.qlik.com/groups/qvscriptor-from-schema-to-script/blog/2011/11/11/understanding-join...

Regards,

Anand

[maxgro]

thanks to Enmanuel Santana and his blog

[maleksafa]

join will allow you to merge (join) two tables based on the common key field, so when you apply a normal join only the rows that are matching between the two tables will be joined together and the rest will be deleted, you will end up with one table.

the keep join does the same behavior of the join but without merging the tables, in other words it will keep only the data that have a link (on the common key) in the two tables and delete the rest.

[#5]

Hi Hita,

a basic search on the community will yield the answer to many questions you might have including this one.

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

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

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

you'll find the search option in the right hand corner of the page

hope that helps

Joe