Skip to main content
Announcements
Join us at Qlik Connect for 3 magical days of learning, networking,and inspiration! REGISTER TODAY and save!
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