Skip to main content

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
QlikWorld 2023, a live, in-person thrill ride. Save $300 before February 6: REGISTER NOW!
cancel
Showing results for 
Search instead for 
Did you mean: 
balanandam
Creator II
Creator II

Add new column to QVD

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

16 Replies
shiveshsingh
Master
Master

Is that column also having values corresponding to previous data?

big_dreams
Creator III
Creator III

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

Regards

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
balanandam
Creator II
Creator II
Author

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

Br, Balanandam

jonathandienst
Partner - Champion III
Partner - Champion III

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
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
Creator III
Creator III

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
Creator
Creator

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