topic Re: Help with SQL Inner Join Syntax in Qlikview in QlikView

Help with SQL Inner Join Syntax in Qlikview

Tue, 24 Jun 2014 20:31:18 GMT

I have 2 tables that I'd like to join reight from the SQL Select and not from QVD's. Can someone help me with the SQL syntax i would need within QV? I am trying to inner join on "device_form_sk". Thanks

SQL SELECT

     "device_sk",
     "device_form_sk"
FROM "mob_dw"."device_dim";

SQL SELECT "device_form_sk",
   "device_form_cd",
    "device_form_desc" as "Device Form"
FROM "mob_dw"."device_form_dim";

Re: Help with SQL Inner Join Syntax in Qlikview

maxgro — Tue, 24 Jun 2014 21:09:11 GMT

maybe

SQL SELECT

a. "device_sk",
a."device_form_sk",

b."device_form_cd",

b."device_form_desc" as "Device Form"

FROM "mob_dw"."device_dim" a,
"mob_dw"."device_form_dim" b

where a."device_form_sk"= b."device_form_sk";

Re: Help with SQL Inner Join Syntax in Qlikview

Tue, 24 Jun 2014 22:01:33 GMT

Hi,

try using preceding load:

Table1:

Load

device_sk,

device_from_sk;

SQL SELECT

"device_sk",
"device_form_sk"
FROM "mob_dw"."device_dim";

inner join(Table1)

Table2:

Load

device_from_sk, // your link key

device_from_cd,

[Device From];

SQL SELECT "device_form_sk",
"device_form_cd",
"device_form_desc" as "Device Form"
FROM "mob_dw"."device_form_dim";

Best regards.

Re: Help with SQL Inner Join Syntax in Qlikview

jagan — Wed, 25 Jun 2014 02:35:00 GMT

Hi John,

Try like this

Table1:

SQL SELECT

"device_sk",
"device_form_sk"
FROM "mob_dw"."device_dim";

inner join(Table1)

SQL SELECT "device_form_sk",
"device_form_cd",
"device_form_desc" as "Device Form"
FROM "mob_dw"."device_form_dim";

Hope this helps you.

Regards,

Jagan.