QlikView App Dev

[knkirubakaran]

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

[swuehl · Accepted solution]

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

[ravikumar_iyana]

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