Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
b_garside
Partner - Specialist
Partner - Specialist

Concatenate two resident tables

I need to concatentate these tables.. Right now its simply droping the DCR_Solutions and leaving a Synthetic table.

I'm sure its a simple issue at play here.

All_Solutions:
LOAD *
Resident DCR_Solutions;

Concatenate //(All_Solutions)

LOAD *
Resident Materiel_Solutions;


Drop Tables  DCR_Solutions;

15 Replies
CELAMBARASAN
Partner - Champion
Partner - Champion

Hi,

You have used EXIT Script in the combine tab is this you done it for testing? Could you please check it?

b_garside
Partner - Specialist
Partner - Specialist
Author

it was.  after reload the data is gone from drop statements. I placed to make sure it didnt get erased.

CELAMBARASAN
Partner - Champion
Partner - Champion

Check with this script.

T2:

NoConcatenate

LOAD *

Resident DCR_Solutions;

Concatenate(T2)

LOAD *

Resident Materiel_Solutions;

Drop Tables  Materiel_Solutions, DCR_Solutions;

b_garside
Partner - Specialist
Partner - Specialist
Author

It worked!  I guess I needed to  place NoConcatenate etc for it to work ?

b_garside
Partner - Specialist
Partner - Specialist
Author

Ok so it was concatenating from the tables in the previous tabs.

CELAMBARASAN
Partner - Champion
Partner - Champion

Yes absolutely.