Joining tthree QVDs with same fields

[mishraamit2485]

Hi Experts,

Our current implementation is like

load *;

SQL

select

A,

B,

C

From Table1

Concatenate

load *;

SQL

select

A,

B,

C

From Table2

Concatenate

load *;

SQL

select

A,

B,

C

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)

[Anonymous]

NameTable:

load *;

SQL

select

A,

B,

C

From Table1

Concatenate

load *;

SQL

select

A,

B,

C

From Table2

Concatenate

load *;

SQL

select

A,

B,

C

From Table3

Store * from  NameTable  into ABC.QVD

Drop Table NameTable

[jolivares]

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...

[mishraamit2485]

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.

[mishraamit2485]

After that Concatenate all of them?

[pamaxeed]

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

[Anonymous]

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

ABC1:

load *;

SQL

select

A,

B,

C

From Table1

Store * from  ABC1 into ABC1.QVD

Drop Table ABC1

ABC2:

load *;

SQL

select

A,

B,

C

From Table2

Store * from  ABC2 into ABC2.QVD

Drop Table ABC2

ABC3:

load *;

SQL

select

A,

B,

C

From Table3

Store * from  ABC3 into ABC3.QVD

Drop Table ABC3

Regards

[mishraamit2485]

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 ?

[Anonymous]

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.

[maxgro]

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 ..............;