Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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
I dont wanna concatenate, doing this wont give u flexible association
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
can I ask the reason to store 5 tables (qvd) in one qvd?
Yes I wanna make use of 1 QVD
"I wanna" is the weakest possible reason I know of
Keeping separate QVDs gives the most flexibility, as you've noticed above already.
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 .
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;
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...