topic Add extra data in a QVD in QlikView

Add extra data in a QVD

Fri, 24 Sep 2010 08:57:59 GMT

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

Add extra data in a QVD

Miguel_Angel_Baeyens — Fri, 24 Sep 2010 09:21:51 GMT

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;

Add extra data in a QVD

Fri, 24 Sep 2010 09:22:13 GMT

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

Add extra data in a QVD

Fri, 24 Sep 2010 13:38:32 GMT

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;

Add extra data in a QVD

Miguel_Angel_Baeyens — Fri, 24 Sep 2010 13:45:39 GMT

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.