Qlik Community

Ask a Question

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Welcome to our newly redesigned Qlik Community! Read our blog to learn about all the new updates: READ BLOG and REPORTED ISSUES
cancel
Showing results for 
Search instead for 
Did you mean: 
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

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

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

Creator II
Creator II

Thanks for your repply. Your assumption is correct.