Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

delete the contents of a qvd file, but keep the table structure

Hi,

I have not been working long with QV and have now taken an old project in my company.

In the existing script, qvd files can be read and updated. However, I do not want to take over this old data and would need to delete the contents of the qvd file, but retain the table structure.

How can I delete the contents of a qvd file, but keep the table structure?

With kind regards

Philipp Schöck

1 Reply
marcus_sommer

Try this:

qvd:

Load * From qvd.qvd (qvd) where 1>2;

store qvd into qvd.qvd (qvd);

- Marcus