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

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

rajveersinghsisodiya — Tue, 16 Sep 2014 06:45:28 GMT

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.

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

Tue, 16 Sep 2014 06:47:40 GMT

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 ..?

avinashelite — Tue, 16 Sep 2014 06:50:28 GMT

Hi Rajveer,

Use Partial Reload concept for this kind of situation.

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

Anonymous — Tue, 16 Sep 2014 06:50:31 GMT

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

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

amit_saini — Tue, 16 Sep 2014 06:51:39 GMT

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,

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

jagan — Tue, 16 Sep 2014 06:53:22 GMT

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.

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

ajaykumar1 — Tue, 16 Sep 2014 06:56:52 GMT

Hi,

Try like this;

Existing:

Load A,

.....

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

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

Tue, 16 Sep 2014 07:06:04 GMT

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

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

ashfaq_haseeb — Tue, 16 Sep 2014 07:44:19 GMT

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