topic Re: Can partial data from a QVD file be deleted? in QlikView

Can partial data from a QVD file be deleted?

rahulhv1 — Wed, 12 Feb 2014 07:13:19 GMT

I have a qvd e.g. Sales.qvd, i want to delete records from a qvd for a perticular data, is it possible,?

michaelvporat — Wed, 12 Feb 2014 07:16:28 GMT

Hi why don't you download the qvd in a new qvw and filter the records you would like to save, store it into a new qvd file.

regards,

Mikael

Wed, 12 Feb 2014 07:16:34 GMT

try accrding to this

Sales:

load * from D:/Sales.qvd (qvd)

where ID <> 3;

store Sales into D:/Sales.qvd (qvd);

MK_QSL — Wed, 12 Feb 2014 07:18:27 GMT

Load the data from QVD with using some condition

and override the old QVD by storing this table using the same name...