How to do an efficient join and union in Qlik

[julioarriaga]

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.

[sunny_talwar · Accepted solution]

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]

Thanks for your repply. Your assumption is correct.