topic Re: Inner join issue in QlikView

Inner join issue

Fri, 19 Sep 2014 17:10:03 GMT

Hi All,

I have to get A1, A2, A3, A4, C3 into my QLikview table and it is giving error saying that C3 not existed.

Tab1:

A1 A2 A3 A4

Tab2:

B1 B2 B3

Tab3:

C1 B2 C3

LOAD A1,A2, A3, A4, C3;

sql SELECT * FROM

SQL SELECT * FROM tab1 a

left join Tab2 b on a.A1 = b.B2

left join Tab3 c on b.B1 = c.C1;

Re: Inner join issue

maxgro — Fri, 19 Sep 2014 20:18:46 GMT

remove bold

LOAD A1,A2, A3, A4, C3;

//sql SELECT * FROM

SQL SELECT * FROM tab1 a

left join Tab2 b on a.A1 = b.B2

left join Tab3 c on b.B1 = c.C1;

Re: Inner join issue

sundarakumar — Fri, 19 Sep 2014 20:36:06 GMT

i dont think the error is with qlikview load. try to remove the precedent load and check if C3 is available form the SQL pull. if yes check on what name it is getting loaded into qlikview. if no ur SQL query to pull data should be revisited.

and yes u will have to comment the bold line specified by massimo.

-Sundar