topic How to do an efficient join and union in Qlik in QlikView

How to do an efficient join and union in Qlik

julioarriaga — Wed, 25 Apr 2018 17:36:05 GMT

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 — Wed, 25 Apr 2018 17:42:38 GMT

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 — Wed, 25 Apr 2018 17:53:32 GMT

Thanks for your repply. Your assumption is correct.