topic Re: Joining tthree QVDs with same fields in QlikView

Joining tthree QVDs with same fields

mishraamit2485 — Tue, 22 Sep 2015 16:06:52 GMT

Hi Experts,

Our current implementation is like

load *;

SQL

select

From Table1

Concatenate

load *;

SQL

select

From Table2

Concatenate

load *;

SQL

select

From Table3

Store into ABC.QVD

and this ABC.qvd is feeding to my QVW(Two tier Architecture)

now because of some reason i have to implement some thing like create three separate QVD's from three table(ABC1.qvd, ABC2. qvd,ABC3.qvd) and than merge them in one QVD (ABC.qvd).

my question is can i introduce one more qvd gen (Three tier architecture) and do something like ABC1.qvdConcatenateABC2.qvdConcatenateABC3.qvd store into ABC.qvd or use keyword keep or something else.

Please advice.

Note: All the three tables has same fields(A,B,C)

Re: Joining tthree QVDs with same fields

Anonymous — Tue, 22 Sep 2015 16:26:19 GMT

NameTable:

load *;

SQL

select

From Table1

Concatenate

load *;

SQL

select

From Table2

Concatenate

load *;

SQL

select

From Table3

Store * from NameTable into ABC.QVD

Drop Table NameTable

Re: Joining tthree QVDs with same fields

jolivares — Tue, 22 Sep 2015 16:30:10 GMT

Thats not a problem, just sotre every QVD into a separate QVD, without taking care about the name of the fields.

ABC1.QVD have the same fields of ABC2.QVD but not the same data.

Table1:

Load ... from Table1;

Store Table1 ...

Drop table Table1;

and so on...

Re: Joining tthree QVDs with same fields

mishraamit2485 — Tue, 22 Sep 2015 16:35:45 GMT

But the point is I have to create three QVD Gen, QVDGEN1, QVDGEN2,QVDGen3 (Some business need) to create three QVDs ABC1.qvd,ABC2.qvd,ABC3.QVD now I have three QVDs and I have to join or concatenate them in one qvd ABC.qvd.

Note its must to create the QVDs using three diff QVD Gen once QVD's are generated we need to merge them in one.

Re: Joining tthree QVDs with same fields

mishraamit2485 — Tue, 22 Sep 2015 16:36:54 GMT

After that Concatenate all of them?

Re: Joining tthree QVDs with same fields

pamaxeed — Tue, 22 Sep 2015 16:42:57 GMT

Simply store them in 3 .qvd and add an additional layer where you concatenate them in one table and store it as single .qvd. What concerns you about that?

Regards,

Patric

Re: Joining tthree QVDs with same fields

Anonymous — Tue, 22 Sep 2015 16:53:48 GMT

if you need separate the tables, you don't use concate, and create a new qvd for each table .

ABC1:

load *;

SQL

select

From Table1

Store * from ABC1 into ABC1.QVD

Drop Table ABC1

ABC2:

load *;

SQL

select

From Table2

Store * from ABC2 into ABC2.QVD

Drop Table ABC2

ABC3:

load *;

SQL

select

From Table3

Store * from ABC3 into ABC3.QVD

Drop Table ABC3

Regards

Re: Joining tthree QVDs with same fields

mishraamit2485 — Tue, 22 Sep 2015 17:19:13 GMT

Sorry for the confusion, i think i was not able to explain properly.

Let me try again.

you know how i was doing earlier (Creating one qvd ABC.qvd by concatenating three tables and my qvw was reading with that)

Now i have three qvd's (ABC1.qvd and so on... no concatenation of three tables now) so point is I want to merge those 3 QVDs (ABC1.qvd concatenate ABC2.qvd so on) in one QVD.

so question is is it possible to concatenate three qvd's(Having same fields) in one qvd ?

Re: Joining tthree QVDs with same fields

Anonymous — Tue, 22 Sep 2015 17:29:25 GMT

ok, basically you have to do is concatenate the 3 qvd and save it into one.

ABC:

load *

from

ABC1.QVD(qvd);

Concatenate

load *

from

ABC2.QVD(qvd);

Concatenate

load *

from

ABC3.QVD(qvd);

Store * from ABC into newQVD.QVD

Drop Table ABC

Regards.

Re: Joining tthree QVDs with same fields

maxgro — Tue, 22 Sep 2015 19:34:32 GMT

to concatenate qvd you have to read them

Table:

load * from qvd1.qvd (qvd);

concatenate (Table1) load * from qvd2.qvd (qvd);

concatenate (Table1) load * from qvd3.qvd (qvd);

you can remove the bold part if all the fields are the same (number and name)

and then store the Table into a new qvd

store ..............;