This content has been marked as final. Show 3 replies
I have 6 tables : A1, A2, A3, B1, B2, B3.
I would like to have one big table like this :
A1 concatenate A2 concatenate A3
B1 concatenante B2 concatenante B3
What is the more efficient way to do it ?
So far, I have done:
LOAD * from A1;
LOAD * from A2;
LOAD * from A3;
STORE A into A.qvd;
LOAD * from B1;
LOAD * from B2;
LOAD * from B3;
STORE B into B.qvd;
LOAD * from A.qvd(qvd);
LOAD * from B.qvd(qvd);
That is the only syntax I have found to do it. But I realize I export data in qvd and right after import them so there is probably a more efficient way to do it.
Do you have any idea ?
Thanks for your help