Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

Concatenante and joins

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

1 Solution

Accepted Solutions

Re: Concatenante and joins

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 Replies

Re: Concatenante and joins

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

Not applicable

Re: Concatenante and joins

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

You are doing a good job ...

Community Browser