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

Announcements
Qlik Open Lakehouse is Now Generally Available! Discover the key highlights and partner resources here.
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;