Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

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

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

Try this:

qvd:

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

store qvd into qvd.qvd (qvd);

- Marcus

Community Browser