Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
julioarriaga
Creator II
Creator II

How to do an efficient join and union in Qlik

Hi everyone,

I am trying to do the most efficient way possible in Qlik, the following query:

SELECT *

FROM Table1

LEFT JOIN (SELECT *

                    FROM TABLE2

                    UNION

                    SELECT *

                    FROM TABLE3

                    ) Table4 on Table1.JoinedField=Table4.JoinedField;

Thanks a lot in advance for your help.

Kind regards.

1 Solution

Accepted Solutions
sunny_talwar

May be this

Table:

LOAD  *

FROM TABLE2;

Concatenate (Table)

LOAD *

FROM TABLE3;

Right Join (Table)

LOAD *

FROM TABLE1;

The assumption here is the JoinedField is the only common field between TABLE2, TABLE3 and TABLE1

View solution in original post

2 Replies
sunny_talwar

May be this

Table:

LOAD  *

FROM TABLE2;

Concatenate (Table)

LOAD *

FROM TABLE3;

Right Join (Table)

LOAD *

FROM TABLE1;

The assumption here is the JoinedField is the only common field between TABLE2, TABLE3 and TABLE1

julioarriaga
Creator II
Creator II
Author

Thanks for your repply. Your assumption is correct.