Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

sisodiya_rajvee
New Contributor II

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

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.

8 Replies
Not applicable

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

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.

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

Hi Rajveer,

Use Partial Reload concept for this kind of situation.

konstantin
Contributor III

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

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

amit_saini
Honored Contributor III

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

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

MVP
MVP

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

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
Contributor III

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

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

Not applicable

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

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


Highlighted

Re: How to add a Column to an already existing 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

Community Browser