topic Re: Concatenante and joins in QlikView

Concatenante and joins

Mon, 20 Oct 2014 09:16:48 GMT

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:

LOAD * from A1;

concatenate

LOAD * from A2;

concatenate

LOAD * from A3;

STORE A into A.qvd;

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

Re: Concatenante and joins

alexandros17 — Mon, 20 Oct 2014 09:20:31 GMT

After A: write NoConcatenate and so for B:

So A:

noconcatenate

....

noconcatenate

Do not export to qvd

just write:

noconcatenate

LOAD * resident A;

LEFT JOIN

LOAD * resident B;

drop tables A,B;

in this way you are working in memory

Re: Concatenante and joins

Mon, 20 Oct 2014 09:28:57 GMT

thank you Alessandro !

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

It does work better.

Have a good day !

Re: Concatenante and joins

alexandros17 — Mon, 20 Oct 2014 09:34:05 GMT

You are doing a good job ...