How do i store multiple data from different qvd in to one

[#1]

Hello,

I loaded 5 qvd to a qvw how do i store all to form one qvd

i.e:

[First]:

load

.

.

from..... QVD

[Second]:

load

.

.

from..... QVD

[Third]:

load

.

.

from..... QVD

.

.

.

.

Store all into a qvd

[sunny_talwar]

UPDATE:
you will either have to concatenate or join them into one table and then store it into a qvd. As per my understanding you can only store one table per qvd.

First:

load

.

.

from..... QVD

Concatenate (First)

load

.

.

from..... QVD

Concatenate (First)

load

.

.

from..... QVD

.

.

.

Store First into location.qvd (qvd)

HTH

Best,

S

[#3]

I dont wanna concatenate, doing this wont give u flexible association

[sunny_talwar]

If you want to save the data structure as it is and don't want to combine them into one, then I think you can save them as a qvw file as do a Binary load.

Best,

S

[maxgro]

can I ask the reason to store 5 tables (qvd) in one qvd?

[#6]

Yes I wanna make use of 1 QVD

[Anonymous]

"I wanna" is the weakest possible reason I know of

Keeping separate QVDs gives the most flexibility, as you've noticed above already.

[maxgro]

Concatenate as already suggested; add a field to remember the source qvd.

But, IMHO, this isn't the correct way to use the qvd; 1 qvd is for 1 table.

If you have 5 already associated tables, store in 5 .qvd; when you need those tables, read the 5 qvd in a different qvw document and you'll get the same in memory db; you can also only read some of the qvd. I think this is more  flexible than 5 tables in 1 qvd.

if you want to store all your model (database = many tables) in one file for later reuse, use a .qvw and a binary load to read it .

[Anonymous]

Although, if you want a worse solution, I can give you a bad advice:

First:

load

1 as TableNum,

...

from..... QVD;

Concatenate (First)

load

2 as TableNum

...

from..... QVD;

Concatenate (First)

load

3 as TableNum

.

from..... QVD;

............

Store First into Full.qvd (qvd);

When you read from QVD, and want only Second table:

LOAD

...                             // all fields except TableNum here

FROM ...

WHERE TableNum=2;

[#10]

Hello All,

I pulled my data from SAP BW using QvSAPOLAPConnector storing to QVD and pushing my data direct to MS SQL so i can manipulate my data there. Am not saying i want to make use of one QVD because i just wanna make use of it plz...