Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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);
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);