Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
CUSTOMERS ONLY: Now accepting customer applications for the 2023 Luminary Program: SUBMIT NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
knkirubakaran
Contributor III
Contributor III

How to Inner Join multiple tables into single table

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

Inner Join.jpg

1 Solution

Accepted Solutions
swuehl
MVP
MVP

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

View solution in original post

2 Replies
swuehl
MVP
MVP

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
Creator
Creator

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