How to add a Column to an already existing QVD ..?

[rajveersinghsisodiya]

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.

[#2]

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.

[avinashelite]

Hi Rajveer,

Use Partial Reload concept for this kind of situation.

[Anonymous]

You can load only missed columns with table key field to the separate table and join with existing table by key field.

[amit_saini]

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

[jagan]

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.

[ajaykumar1]

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

[#8]

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

[ashfaq_haseeb]

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