Add new column to QVD

[balanandam]

Hi all,

I have a new column added to my source database, and that should be pulled out to qlikview and append to existing qvd. what is the best way to do this ?

I know the method, run full extract and create qvd starting onwards, but the data size is in very big that takes hours to complete this. As now I am loading data incremental manner to qlikview. Pls. suggest.

Br, Balanandam

[shiveshsingh]

Is that column also having values corresponding to previous data?

[big_dreams]

Yes you have to run full extractor. There is no alternate way.

Regards

[jonathandienst]

If the new column is based only on other columns already in the QVD, then it will not be necessary to run the full reload. Create a simple model that loads the qvd with the calculated column and store the qvd

Data:

LOAD *,

     <new derived column calculation> as NewColumn

FROM $(vqvdPath)\YourData.qvd (qvd);

STORE Data into $(vqvdPath)\YourData.qvd (qvd);

[balanandam]

No, this column has created recently and start logging data.

Br, Balanandam

[jonathandienst]

How are the rows in the new column related to the existing rows?

[akshaye_c_navale]

You can modify existing QVD by adding new Column and set its default value either blank or NULL.

LOAD *,

     <new column > as NewColumnName

FROM $(vQVDPath)\Data.qvd (qvd);

STORE Data into $(vQVDPath)\Data.qvd (qvd);

DROP TABLE Data

[qlik4asif]

what i understood is you have a QVD,and new column was inserted in DB,

now you want to extract this column from DB and append it to existing QVD.

How abt this way!!!!!!!!!

QVD:                                                       //Loading existing QVD

LOAD *

FROM $(vqvdPath)\YourData.qvd (qvd);

Join                                                                 //new column added to qvd w.r.t to commonfield(Key)

NewField:

Load <Commonfield>,

     <Newfield>

From DB;

STORE QVD into $(vqvdPath)\YourData.qvd (qvd);

[akshaye_c_navale]

You don't need to used Join.

If you want to bring New columns data for Historical data also then better perform Full data load.

[Akina0929]

use partial Reload it is used to load some tables in data model instead of loading all tables.