Joins In Qlikview

[rahulsingh12]

hi,

I have 4 tables A,B,C,D.

I have joined A,B,C using left join on basis of a common key among them.

I want to join D to the above 3 such that all the records from D (one which match to the above 3 joined table and one which does not match to the above 3 data) should come.

How do I join these tables.

Regards,

[its_anandrjs]

Try some with this

A:

Load * From A;

Left Join(A)

Load * From B;

Left Join(A)

Load * From C;

Outer Join(A)

Load * From D;

[rahulsingh12]

Hi,

I did the same but when.

To recognize the columns i qualified the fields of each table but when I select any column from table A,B,C nothing gets selected in table D although the Key with which I join D with other tables is getting selected.

I don't know what is wrong in the outer join.

Regards,

[rahulsingh12]

A:

load *

Inline

[

Productid,Cost,Diff

1,100

2,1000

6,19

];

outer join

B:

load

*

Inline

[

Productid,Cost,Diff

2,1000,199

4,100,100

];

here I'll get 2 records of 1000 with null as diff and 199 as diff.

Is possible to merge these two rows?

[rohitraut]

hello Rahul,

try this,

A:

load *

Inline

[

Productid,Cost

1,100

2,1000

6,19

];

outer join

load

*

Inline

[

Productid,Cost,Diff

2,1000,199

4,100,100

]

[its_anandrjs]

When ever using the joins always check which joins you have to use (Left,Right,Inner,Outer) and it all depends on your table keys.

Also read this joins related thread the help you

Different Join Functions in Qlikview

Some Qlikview Joins best documents

For your script you can simply use Join and keep only required fields on the table.

A:

load * Inline

[

Productid,Cost

1,100

2,1000

6,19

];

Join

B:

load * Inline

[

Productid,Cost,Diff

2,1000,199

4,100,100

];