topic Re: left or inner join in qlikview in QlikView

left or inner join in qlikview

Anonymous — Fri, 15 Sep 2017 07:04:20 GMT

how does join work in qlikview: table 1 fields:a and field b field a has 3 values 1 2 3 field b has abd xyz. nky values against it, and table 2 has field a and field b field a has 2 3 4 and field b has bhg jhk lnh values how inner join wil be performed in this, with respect to which tble what will be the output fr this

Re: left or inner join in qlikview

Miguel_Angel_Baeyens — Fri, 15 Sep 2017 07:07:32 GMT

I see no format in your data so difficult to say based on the example. The INNER and LEFT JOIN will behave as expected, the former keeping only rows which match in both tables and the latter resulting in a table which keeps rows with values existing only on the first table to load.

More info in

Inner ‒ QlikView

Re: left or inner join in qlikview

its_anandrjs — Fri, 15 Sep 2017 07:08:27 GMT

Have a look few of this documents

https://community.qlik.com/docs/DOC-7457

Different Join Functions in Qlikview

Regards

Anand

Re: left or inner join in qlikview

its_anandrjs — Fri, 15 Sep 2017 07:12:18 GMT

If using inner join the result you get it common fields or rows in between this tables you get the result as 2,3 from a on both the tables

Load * inline

[

a,b

1,abd

2,xyz

3,nky

];

Inner join

Load * inline

[

a,b

2,bhg

3,jhk

4,inh

];

Re: left or inner join in qlikview

Anonymous — Fri, 15 Sep 2017 07:56:15 GMT

that means it wil take frst table as refrence unlike SQL where u use ON statement

Re: left or inner join in qlikview

Anonymous — Fri, 15 Sep 2017 07:58:38 GMT

is there any dfrnce in joins in SAS/sql and qlikview

Re: left or inner join in qlikview

its_anandrjs — Fri, 15 Sep 2017 08:00:45 GMT

In the Both that table you have same records is the inner join.

Re: left or inner join in qlikview

Miguel_Angel_Baeyens — Fri, 15 Sep 2017 09:35:41 GMT

No, an inner join is an inner join and has the same effect on SQL tables than on QlikView tables. Obviously the syntax is different as QlikView uses a loading script language loosely based on SQL, but not the same keywords and not in the same order (i.e.: in QlikView scripting, you don't need an ON clause).

INNER means a resulting table with the matching rows of both tables based on the key field or fields between them
LEFT means a resulting table with the all the rows of the first table and the matching rows from the second table based on the key field or fields.

For the reference, examples and syntax, you can peruse both Anand's and myself links will do.