Qlik Community

QlikView Integration

Discussion Board for collaboration on QlikView Integration.

Highlighted
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
Honored Contributor III

Re: How to define two joins between 2 tables?

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);

1 Reply
anbu1984
Honored Contributor III

Re: How to define two joins between 2 tables?

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);