Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Is this possible to reset the content of a qvd file?
How could i do this easily?
Thanks,
Best Regards,
Loïc
Hi
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
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.
Hi
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
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;