Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
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