Qlik Community

New to QlikView

Discussion board where members can get started with QlikView.

Announcements
Qlik Analytics Tour 2020 Online. Begins August 10th. Register Today
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Creator
Creator

When will use join & Keep

Hi,

I want to know the exact difference between join and Keep join .I know the usage of both but I want to know in which situation I use Join and Keep join .

If I use join what is the advantage/disadvantage with respect to Keep joins.

Please help me to understand this functionality how it works.

Thanks in Advance.

1 Solution

Accepted Solutions
Highlighted
Champion III
Champion III

Re: When will use join & Keep

hi

PFA

hope this helps u

Thank you

Suresh

View solution in original post

7 Replies
Highlighted
Specialist
Specialist

Re: When will use join & Keep

well it depends on your data model, if it is better to combine two tables using join or keeping the two tables separated but having only the linked data.

so you should consider the size of the table that you want to join and whether it is a linked table or not, usually in the case of a linked table you don't want to join it.

Highlighted
Champion III
Champion III

Re: When will use join & Keep

hi

PFA

hope this helps u

Thank you

Suresh

View solution in original post

Highlighted
Creator II
Creator II

Re: When will use join & Keep

Check this document

Highlighted
Creator
Creator

Re: When will use join & Keep

is there any performance difference ?

Highlighted
MVP & Luminary
MVP & Luminary

Re: When will use join & Keep

Hi Sudhakar,

Check this link hope it helps you in understanding this concepts

Understanding Join, Keep and Concatenate

Regards,

Jagan.

Highlighted
Master II
Master II

Re: When will use join & Keep

PFA

Highlighted
Creator II
Creator II

Re: When will use join & Keep

Hi,

If u want to make two different tables into one in your data model with one common key then u can use join.

But if u want to keep two tables as it is and want a relation(Join) between them then you can use keep.