Concatenante and joins

[#1]

Hello everyone,

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

LEFT JOIN

B1 concatenante B2 concatenante B3

What is the more efficient way to do it ?

So far, I have done:

A:

LOAD * from A1;

concatenate

LOAD * from A2;

concatenate

LOAD * from A3;

STORE A into A.qvd;

B:

LOAD * from B1;

concatenate

LOAD * from B2;

concatenate

LOAD * from B3;

STORE B into B.qvd;

And then

LOAD * from A.qvd(qvd);

LEFT JOIN

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

[alexandros17 · Accepted solution]

After A: write NoConcatenate and so for B:

So A:

noconcatenate

....

B:

noconcatenate

Do not export to qvd

just write:

C:

noconcatenate

LOAD * resident A;

LEFT JOIN

LOAD * resident B;

drop tables A,B;

in this way you are working in memory

[#3]

thank you Alessandro !

I am feeling stupid not to have thought of "resident"

It does work better.

Have a good day !

[alexandros17]

You are doing a good job ...