Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please help me to do inner join in multiple tables as like below image in qlikview
Qlik only allows a single source table joined to another single resident table in one statement, so
just LOAD a resident table in your script, then a second table with an INNER JOIN LOAD prefix and appropriate key fields. Same with the other tables.
LOAD
Key,
OtherFieldA
FROM ...;
INNER JOIN
LOAD
Key,
Key2,
OtherFieldB,
FROM ...;
INNER JOIN
LOAD Key2,
OtherFieldC
FROM ...;
Qlik only allows a single source table joined to another single resident table in one statement, so
just LOAD a resident table in your script, then a second table with an INNER JOIN LOAD prefix and appropriate key fields. Same with the other tables.
LOAD
Key,
OtherFieldA
FROM ...;
INNER JOIN
LOAD
Key,
Key2,
OtherFieldB,
FROM ...;
INNER JOIN
LOAD Key2,
OtherFieldC
FROM ...;
Hi,
Based on your requirement 'Inner Join'
Between (1):
T4:
INNERJOIN
T6:
Result: with t4 table display
Between(2):
T3:
INNERJOIN
T5:
Result: with T3 table display
between(3):
t3:
innerjoin
t4:
result: with t3(1)
between(4):
t2:
innerjoin
t3(1)
result: with t2 table display
between(5):
t1:
innerjoin
t2:
final result will display