topic Re: When will use join & Keep in QlikView

When will use join & Keep

svsudhakar — Mon, 06 Jul 2015 06:35:20 GMT

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.

Re: When will use join & Keep

maleksafa — Mon, 06 Jul 2015 06:43:30 GMT

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.

Re: When will use join & Keep

Chanty4u — Mon, 06 Jul 2015 06:44:54 GMT

PFA

hope this helps u

Thank you

Suresh

Re: When will use join & Keep

svenkita — Mon, 06 Jul 2015 06:47:16 GMT

Check this document

Re: When will use join & Keep

svsudhakar — Mon, 06 Jul 2015 06:49:42 GMT

is there any performance difference ?

Re: When will use join & Keep

jagan — Mon, 06 Jul 2015 06:52:07 GMT

Hi Sudhakar,

Check this link hope it helps you in understanding this concepts

Understanding Join, Keep and Concatenate

Regards,

Jagan.

Re: When will use join & Keep

Siva_Sankar — Mon, 06 Jul 2015 06:53:07 GMT

PFA

Re: When will use join & Keep

help4qv123 — Mon, 06 Jul 2015 06:53:18 GMT

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.