Qlik Community

QlikView Deployment

Discussion Board for collaboration related to QlikView Deployment.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
kush141087
Not applicable

Re: Union and join tables

try this

temp:

Load * from B;

Concatenate(temp)

Load * from C;

join(temp)

Load * from A;


you can change your join type accordingly

4 Replies
surendraj
Not applicable

Re: Union and join tables

Load * from A;

inner join

temp:

Load * from B;

Concatenate(temp)

Load * from C

where not exists(key coloumn);

kush141087
Not applicable

Re: Union and join tables

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
Not applicable

Re: Union and join tables

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

Re: Union and join tables

Thank you so much