Joining Tables - Qlikview Vs RDBMS/Database

Sun, 20 Apr 2014 23:50:22 GMT

In RDBMS, we can specify which columns we want to join on. Can we do the same in Qlikview 11 ?

Eg. consider some "logical tables" - Table1(Field1, Field2, Field3), Table2(Field7, Field8, Field9)

SQL -

Select *

from Table1 as t1

left join Table2 as t2

on t1.Field1 = t2.Field9

and t1.Field2 = (t2.Field7 + 1)

Here, we do NOT want to join on Field3 and Field9.

Can Qlikview do something similar as imagined below ?

[t1]:

LOAD

Field1, Field2, Field3

FROM [your CSV file];

//[t2]:

LEFT JOIN ([t1])

LOAD

Field7, Field8, Field9

FROM [Your CSV file]

on t1.Field1 = t2.Field9

and t1.Field2 = (t2.Field7 + 1)

Re: Joining Tables - Qlikview Vs RDBMS/Database

jagan — Mon, 21 Apr 2014 04:11:22 GMT

Hi John,

In qlikview the tables automatically join if column names are same, try like this

[t1]:

LOAD

Field1, Field2, Field3

FROM [your CSV file];

//[t2]:

LEFT JOIN ([t1])

LOAD

Field7 + 1 AS Field2,

Field7,

Field8,

Field9 as Field1,

Field9

FROM [Your CSV file];

Hope this helps you.

Regards,

Jagan.