Qlik Community

Ask a Question

QlikView Integration

Discussion Board for collaboration on QlikView Integration.

Announcements
Qlik Highlights 2020 Giveaway! Watch, reply and have a chance to win a $200 Amazon Gift Card! Watch Video
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
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
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