Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
Modernize Your QlikView Deployment webinar, Nov. 3rd. REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
Not applicable

Add extra data in a QVD

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

4 Replies
Highlighted

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;


Highlighted
Not applicable

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

Highlighted
Not applicable

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;



Highlighted

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.