Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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;
Hi,
You have used EXIT Script in the combine tab is this you done it for testing? Could you please check it?
it was. after reload the data is gone from drop statements. I placed to make sure it didnt get erased.
Check with this script.
T2:
NoConcatenate
LOAD *
Resident DCR_Solutions;
Concatenate(T2)
LOAD *
Resident Materiel_Solutions;
Drop Tables Materiel_Solutions, DCR_Solutions;
It worked! I guess I needed to place NoConcatenate etc for it to work ?
Ok so it was concatenating from the tables in the previous tabs.
Yes absolutely.