Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Add extra data in a QVD

Is it possible to add extra data to a already existing qvd-file?

4 Replies
Miguel_Angel_Baeyens

Hello,

You can do a partial reload adding new fields to an already loaded table, then store the table (with this new records into the qvd file.

Table: ADD LOAD Field1, Field2 FROM FILE2.QVD (QVD); STORE Table INTO FILE1.QVD;


Not applicable
Author

Hello,

afaik this is not possible, as the qvd is a proprietary, binary format.
Adding data means "load qvd -> append data -> store as qvd".

hth,
Thilo

Not applicable
Author

Miguel I get only the extra sales data in de qvd-file

Sales:









LOAD

STORE

Sales INTO c:\tmp\omzet1.qvd;
Drop table

Sales;

Sales_extra:



`STORE_ID`,`ITEM_ID`,`ORDER_DATE`,`DELIVERY_DATE`,UNITS as aantal, AMOUNT;
SQL SELECT *
FROM`PCW_SALES`
where YEAR(ORDER_DATE) <= 2001;



Miguel_Angel_Baeyens

Hello Alfred,

You need to add the ADD keyword to your load, use the same name than the table previously created and store, and perform a partial reload (File, Partial Reload (Ctrl + Shift + R)).

Otherwise only the latter will be saved overwritting the existing data.