Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

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
Not applicable

Add extra data in a QVD

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

Add extra data in a QVD

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

Add extra data in a QVD

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
Not applicable

Add extra data in a QVD

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.