topic Re: Joins In Qlikview in QlikView

Joins In Qlikview

rahulsingh12 — Mon, 04 Sep 2017 18:00:55 GMT

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,

Re: Joins In Qlikview

its_anandrjs — Mon, 04 Sep 2017 18:18:40 GMT

Try some with this

Load * From A;

Left Join(A)

Load * From B;

Left Join(A)

Load * From C;

Outer Join(A)

Load * From D;

Re: Joins In Qlikview

rahulsingh12 — Mon, 04 Sep 2017 18:40:51 GMT

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,

Re: Joins In Qlikview

rahulsingh12 — Mon, 04 Sep 2017 19:02:34 GMT

load *

Inline

[

Productid,Cost,Diff

1,100

2,1000

6,19

];

outer join

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?

Re: Joins In Qlikview

rohitraut — Tue, 05 Sep 2017 05:37:15 GMT

hello Rahul,

try this,

load *

Inline

[

Productid,Cost

1,100

2,1000

6,19

];

outer join

load

Inline

[

Productid,Cost,Diff

2,1000,199

4,100,100

]

Re: Joins In Qlikview

its_anandrjs — Tue, 05 Sep 2017 06:56:37 GMT

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.

load * Inline

[

Productid,Cost

1,100

2,1000

6,19

];

Join

load * Inline

[

Productid,Cost,Diff

2,1000,199

4,100,100

];