topic Re: How to Inner Join multiple tables into single table in QlikView

How to Inner Join multiple tables into single table

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Please help me to do inner join in multiple tables as like below image in qlikview

Re: How to Inner Join multiple tables into single table

swuehl — Mon, 02 Oct 2017 12:22:22 GMT

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

Re: How to Inner Join multiple tables into single table

ravikumar_iyana — Mon, 02 Oct 2017 14:13:30 GMT

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