topic How to create nested inner join in Qlikview? in QlikView

How to create nested inner join in Qlikview?

Mon, 14 Dec 2015 02:34:41 GMT

Hi,

someone have an example about how to create nested inne join in qlikview?

Regards

Re: How to create nested inner join in Qlikview?

Chanty4u — Mon, 14 Dec 2015 05:05:29 GMT

hi,

Re: qlikview join vs sql joins

Hope this helps u

Thanks

Suresh

Re: How to create nested inner join in Qlikview?

jagan — Mon, 14 Dec 2015 05:18:26 GMT

Hi,

What do you mean by Nested Inner join? Can you attach some sample data and your expected result?

Inner Join Syntax:

Data:

LOAD

FROM DataSource1;

INNER JOIN (Data)

LOAD

FROM DataSource2;

Regards,

Jagan.

Re: How to create nested inner join in Qlikview?

Anonymous — Mon, 14 Dec 2015 05:26:24 GMT

Yea, its possible. You can do nested joins like this:

Table1:

Load *,

ID1

From Table1;

inner join(Table1)

Table2:

Load *,

ID1,

ID2

from Table2;

inner join

Table3:

Load *,

ID2

from Table3;

In this scenario, first Table1 & Table2 will be joined based on ID1 key and then Table3 would be joined Table2 based on ID2 which is already joined to Table1.

After all these joins you will be getting final table i.e Table1.

Hope this will help!!

Re: How to create nested inner join in Qlikview?

Peter_Cammaert — Mon, 14 Dec 2015 08:01:22 GMT

Nested JOINs are a SQL feature and do not exist in QlikView script if you don't specify them in SQL (you can use SQL straightaway however). In QlikView script, all JOINS are sequential, even the ones attached to simple LOADs (IMHO). First the LOAD, then the JOIN.

Note that in theory this isn't much different from what an RDBMS does. A nested JOIN (or SELECT) is just a way of specifying complex operations in a not-too-complex-or-talkative-way. But of course the optimizer may still rearrange the actual execution code into something entirely different.