Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have one QVD and i forgot to add one column in that and table from which i have created the QVD its large.
any way to add a new column to that existing QVD.and i want to add that new column from database.
Without having to reload it ?
Not sure I can see a way around it - add the column to the script, save and then reload on the server would be my best guess.
Hi Rajveer,
Use Partial Reload concept for this kind of situation.
You can load only missed columns with table key field to the separate table and join with existing table by key field.
Rajveer,
Firstly load the qvd which have your additional 5 columns means CusterMaster;
join
load Customer_master qvd;
make sure that in between two qvd's there's one primary key if there is field name change but data is same then use as function or make it same field name
Thanks,
AS
Hi,
Try like this
Data:
LOAD
*
FROM QVDFile.qvd (qvd);
LEFT JOIN
SELECT
KeyColumn,
MissingColumn
FROM TableName;
STORE Data INTO QVDFile.qvd;
Hope this helps you.
Regards,
Jagan.
Hi,
Try like this;
Existing:
Load A,
B,
C,
.....
From XXXXX;
NEW:
ADD Load A, //which is key field
D //missing field(s)
from yyy;
Then save the application and go to front end then file--partial reload.
ADD :The ADD key word is used to reload the only new table(s).Called as partial reload.
It works like mapping will happen between the already loaded table and the newly field added table.
Just try.
Regards,
Ajay
Your QVD is optimised.. when loading from a qvd, its not the same as loading from the database.
Load the existing fields from your qvd and just load the additional one from database into a new qvd. (Give it a new name or rename the old one first.
[Dataconnection String]
YourQVD:
LOAD Key, Rest, Of, QVD FROM C:/YourQVD.qvd (qvd);
Join LOAD Key, OtherField;
SQL SELECT Key, OtherField
FROM DB.dbo.Table;
STORE YourQVD into C:/MyNewQVD.qvd (qvd);
Hi
create an inline table and concatenate, you need to have same field structure for this to work
EX:
Main:
Load
ID,
Name,
from table.qvd
concatenate
Load * inline
[
ID,Name
301,ash
];
store Main into Main.qvd(qvd);
Regards
ASHFAQ