Skip to main content
Announcements
Qlik Introduces a New Era of Visualization! READ ALL ABOUT IT
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Union and join tables

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

1 Solution

Accepted Solutions
Kushal_Chawda

try this

temp:

Load * from B;

Concatenate(temp)

Load * from C;

join(temp)

Load * from A;


you can change your join type accordingly

View solution in original post

4 Replies
surendraj
Specialist
Specialist

Load * from A;

inner join

temp:

Load * from B;

Concatenate(temp)

Load * from C

where not exists(key coloumn);

Kushal_Chawda

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
Master II
Master II

Hi

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

1:

temp:

Load * from B;

Concatenate(temp)

Load * from C;

join(temp)

Load * from A;

2:

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

regards

Pradosh

Learning never stops.
Not applicable
Author

Thank you so much