Discussion Board for collaboration on QlikView Scripting.
Is this possible to reset the content of a qvd file?
How could i do this easily?
Go to Solution.
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:
LOAD * Inline
LOAD Col1 As Col1a, Col2 As Col2a Resident Data Where Col1 = 0;
STORE Data2 into test3.qvd (qvd);
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.
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;