Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Kohli
Creator II
Creator II

why we use keep instead of Joins?

In Joins and Keeps we will get same output. But why we have to use Keep?

4 Replies
jonathandienst
Partner - Champion III
Partner - Champion III

Not true. A keep will result in two tables. A join results in one table.

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
shiveshsingh
Master
Master

May be this can help in a better way..

join.png

shiveshsingh
Master
Master

If you have one to many or many to many relationship then we can use KEEP, because if we use join the records will be duplicated.

petter
Partner - Champion III
Partner - Champion III

You are cross-posting you question which is not according to the Community Guidelines for many reasons...