Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

jasonseril
Contributor

Delete a record in a QVD file

Hello all,

How should i delete a record in a qvd file?

Thanks in advance and more power!

Jason

Tags (2)
2 Replies
MVP
MVP

Delete a record in a QVD file

Hello Jason,

As loading from a QVD is pretty fast, I'd suggest you to load all records in that file except for the one you want to delete, then store it in the same file:

NoRecord:LOAD * FROM FILE.QVD (QVD)WHERE RECID <> 'XXX'; STORE NoRecord INTO FILE.QVD;


Where XXX is the ID for the record (or any other condition) you don't want to save.

Hope this helps.

jasonseril
Contributor

Delete a record in a QVD file

ok miguel, that was a fast reply. thanks again, it helps a lot.

jason

Community Browser