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

How to define two joins between 2 tables?

Hi All,

How to define two joins between 2 tables?

Scenario:

We have two tables, 1 is Product details, 2nd is Conversation rate. so we need to define 2 joins between these 2 tables those are

like

Product.Date=Conversation.Date  and

Product.Country=Conversation.Country

Thanks & Regards

Kumar

1 Solution

Accepted Solutions
anbu1984
Master III
Master III

In Qlikview, you cannot explicitly mention join keys as in Sql. Instead if you have same field names, automatically tables are joined through them. If your join field names are not same, then rename fields in Load.

If you write Load like this, then both the tables are automatically joined through REST and DATE.

Table1:

LOAD USA,

     REST,

     DATE,

     CR

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Table2:

LOAD PRODUCT,

     REST,

     DATE,

     SALE,

     E

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Sheet2);

If you explicitly mention keyword join, then both tables will be merged into one table

Table1:

LOAD USA,

     REST,

     DATE,

     CR

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Join(Table1)

LOAD PRODUCT,

     REST,

     DATE,

     SALE,

     E

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Sheet2);

View solution in original post

1 Reply
anbu1984
Master III
Master III

In Qlikview, you cannot explicitly mention join keys as in Sql. Instead if you have same field names, automatically tables are joined through them. If your join field names are not same, then rename fields in Load.

If you write Load like this, then both the tables are automatically joined through REST and DATE.

Table1:

LOAD USA,

     REST,

     DATE,

     CR

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Table2:

LOAD PRODUCT,

     REST,

     DATE,

     SALE,

     E

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Sheet2);

If you explicitly mention keyword join, then both tables will be merged into one table

Table1:

LOAD USA,

     REST,

     DATE,

     CR

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Sheet1);

Join(Table1)

LOAD PRODUCT,

     REST,

     DATE,

     SALE,

     E

FROM

[Book1.xlsx]

(ooxml, embedded labels, table is Sheet2);