topic What is the difference between join and keep? in Archived Groups https://community.qlik.com/t5/Archived-Groups/What-is-the-difference-between-join-and-keep/m-p/1393058#M360 <HTML><HEAD></HEAD><BODY><P>I am new to qlikview, can any one explain me, difference between join and keep</P></BODY></HTML> Tue, 22 Jul 2025 14:29:37 GMT Anonymous 2025-07-22T14:29:37Z What is the difference between join and keep? https://community.qlik.com/t5/Archived-Groups/What-is-the-difference-between-join-and-keep/m-p/1393058#M360 <HTML><HEAD></HEAD><BODY><P>I am new to qlikview, can any one explain me, difference between join and keep</P></BODY></HTML> Tue, 22 Jul 2025 14:29:37 GMT https://community.qlik.com/t5/Archived-Groups/What-is-the-difference-between-join-and-keep/m-p/1393058#M360 Anonymous 2025-07-22T14:29:37Z Re: What is the difference between join and keep? https://community.qlik.com/t5/Archived-Groups/What-is-the-difference-between-join-and-keep/m-p/1393059#M361 <HTML><HEAD></HEAD><BODY><P>Here's a good explanation with examples:</P><P><A href="https://community.qlik.com/thread/39177">Understanding Join, Keep and Concatenate</A></P><P></P><P>A tip to keep in mind is to not think of a join in SQL terms.&nbsp; If you have table A and you join table B to it, the result is one table still called 'table A' with all the rows of table B appended and B's additional columns added.</P><P></P><P>KEEP acts similar to a join, but a) the result is still having two separate tables, and b) data could be reduced (ie. removed from) one or the other or both tables depending on if you do LEFT, RIGHT, or INNER KEEP.</P></BODY></HTML> Fri, 18 Aug 2017 14:44:32 GMT https://community.qlik.com/t5/Archived-Groups/What-is-the-difference-between-join-and-keep/m-p/1393059#M361 Anonymous 2017-08-18T14:44:32Z