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

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
jonathandienst
Partner - Champion III
Partner - Champion III

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

View solution in original post

3 Replies
Not applicable
Author

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.

jonathandienst
Partner - Champion III
Partner - Champion III

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
maxgro
MVP
MVP

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;