Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Joining Tables - Qlikview Vs RDBMS/Database

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)

1 Solution

Accepted Solutions
jagan
Luminary Alumni
Luminary Alumni

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.

View solution in original post

1 Reply
jagan
Luminary Alumni
Luminary Alumni

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.