topic Re: what is keep and join?explain differences in QlikView

what is keep and join?explain differences

Sun, 25 Jan 2015 07:09:35 GMT

hi everybody

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

Re: what is keep and join?explain differences

its_anandrjs — Sun, 25 Jan 2015 07:19:13 GMT

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-keep-and-concatenate

Regards,

Anand

Re: what is keep and join?explain differences

maxgro — Sun, 25 Jan 2015 21:59:42 GMT

thanks to Enmanuel Santana and his blog

Re: what is keep and join?explain differences

maleksafa — Mon, 26 Jan 2015 12:29:51 GMT

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.

Re: what is keep and join?explain differences

Mon, 26 Jan 2015 12:55:53 GMT

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