topic Re: Union and join tables in QlikView

Union and join tables

Mon, 26 Jan 2026 18:19:17 GMT

Hello Guys,

I have 3 tables, A, B and C. I need to make in Load Script an union between B and C and then a join with A. how can I do?

I tried in this way (it doesn't work):

Load * from A;

inner join

temp:

Load * from B;

Concatenate(temp)

Load * from C;

Tables B and C have the same columns.

Thank you so much

surendraj — Wed, 04 Oct 2017 14:40:13 GMT

Load * from A;

inner join

temp:

Load * from B;

Concatenate(temp)

Load * from C

where not exists(key coloumn);

Kushal_Chawda — Wed, 04 Oct 2017 14:52:13 GMT

try this

temp:

Load * from B;

Concatenate(temp)

Load * from C;

join(temp)

Load * from A;

you can change your join type accordingly

pradosh_thakur — Wed, 04 Oct 2017 15:04:02 GMT

when you joined A and B , B ceases to exist and it is now part of table A that is why concatenate didn't work

Two thing you can try

temp:

Load * from B;

Concatenate(temp)

Load * from C;

join(temp)

Load * from A;

try using keep and see if it works for you and suitable for your requirement

regards

Pradosh

Thu, 05 Oct 2017 13:42:35 GMT

Thank you so much