topic Joining 2 Table in QlikView

Joining 2 Table

aveeeeeee7en — Wed, 26 Mar 2014 17:05:57 GMT

Hi All

I have 2 Separate Tables.

When i Link the 2 tables based on some Primary Key than it gives me desired Result but the Problem is that i cant store its qvd because the 2 Tables are not Joined they are just linked.

So can anyone tell me what is the Best Practice or Method to Join 2 Tables which gives me same result as it gives with Linked Tables.

Regards

Aviral Nag

Re: Joining 2 Table

alexandros17 — Wed, 26 Mar 2014 17:08:50 GMT

outer join is equivalent to linked tables

Re: Joining 2 Table

Aurelien_Martinez — Wed, 26 Mar 2014 17:09:03 GMT

Hi,

You can do this :

Inner join(table1)

Load

Resident table2

;

Aurélien.

Re: Joining 2 Table

Wed, 26 Mar 2014 17:13:07 GMT

Alessandro is correct. Outer Join would be the equivalent to standard link because the outer join includes all records from table A and all records from table B and matches them up where it can. I find this page helpful as I often get joins confused, so maybe it will help you too!

QlikView Addict: Explaining Joins

Re: Joining 2 Table

Nicole-Smith — Wed, 26 Mar 2014 17:13:53 GMT

These two articles should help you understand the best way to join or concatenate your data:

http://qlikviewnotes.blogspot.com/2009/11/understanding-join-and-concatenate.html

http://www.qlikfix.com/2011/02/07/merging-tables-the-join-prefix/