Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements

Breathe easy -- you now have more time to plan your next steps with Qlik!
QlikView 11.2 Extended Support is now valid through December 31, 2020. Click here for more information.

Not applicable

How to reset a qvd?

Hello,

Is this possible to reset the content of a qvd file?

How could i do this easily?

Thanks,

Best Regards,

Loïc

1 Solution

Accepted Solutions
MVP
MVP

Re: How to reset a qvd?

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
3 Replies
Not applicable

Re: How to reset a qvd?

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.

MVP
MVP

Re: How to reset a qvd?

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

Logic will get you from a to b. Imagination will take you everywhere. - A Einstein
MVP
MVP

Re: How to reset a qvd?

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;