topic Re: How to reset a qvd? in QlikView

How to reset a qvd?

Tue, 21 Jan 2014 12:57:58 GMT

Hello,

Is this possible to reset the content of a qvd file?

How could i do this easily?

Thanks,

Best Regards,

Loïc

Tue, 21 Jan 2014 13:03:07 GMT

I think you have to delete the QVD and create a fresh one.

Or you can use incremental loading and then replace the data set with new data set.

jonathandienst — Tue, 21 Jan 2014 13:11:13 GMT

If you mean to update, use a STORE and overwrite the old file. If you mean that want an empty qvd, then you need to store an empty table, like this:

Data:

LOAD * Inline

[

Col1, Col2

1, 2

];

Data2:

NoConcatenate

LOAD Col1 As Col1a, Col2 As Col2a Resident Data Where Col1 = 0;

STORE Data2 into test3.qvd (qvd);

HTH

Jonathan

maxgro — Tue, 21 Jan 2014 13:23:01 GMT

Table:

LOAD * INLINE [

F1, F2, F3, F4

1, 1, a, a

2, 2, b, b

];

Right Keep (Table) load F1 resident Table where 1 = 0;

store Table into table.qvd;