Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

aveeeeeee7en
Not applicable

Joining 2 Table

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

Tags (1)
1 Solution

Accepted Solutions
alexandros17
Not applicable

Re: Joining 2 Table

outer join is equivalent to linked tables

4 Replies
alexandros17
Not applicable

Re: Joining 2 Table

outer join is equivalent to linked tables

amartinez35
Not applicable

Re: Joining 2 Table

Hi,

You can do this :

Inner join(table1)

Load

*

Resident table2

;

Aurélien.

Not applicable

Re: Joining 2 Table

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

Nicole-Smith
Not applicable

Re: Joining 2 Table