Discussion Board for collaboration on QlikView Scripting.
How should i delete a record in a qvd file?
Thanks in advance and more power!
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.
ok miguel, that was a fast reply. thanks again, it helps a lot.