How to delete QVD files using script in qliksense

[Anusha1430]

Hi Team,

I have a requirement to delete QVDs from path whenever I am doing full load in Qlik sense.

Execute command not woks in Qlik sense  and we don't want to Disables Standard mode.

any options are available to achieve this?

Please help me to get the solution for this requirement. It is very urgent requirement in my project.

Thanks in advance

Regards,

Anusha

[Vegar]

There is no built in functionality for deleting files i Qlik Sense, you need to execute this vy another program.

You can however overwrite the qvd files with no data (one column zero rows), if the main purpose is to reduce disk space used on the qvd disk area.

🤔💭: Qlik Sense does have an API which allows you to trigger tasks from other systems. Another approach could be to trigger the reload in another program that is also allowed  to trigger a delete after the Sense task is successful.

[mikaelsc]

i think qlik sense itself will not allow you to delete qvd's. 

either you run an external task (powershell) that you can schedule as a "normal" reload task (recent version of QS required) 

https://help.qlik.com/en-US/sense-admin/August2022/Subsystems/DeployAdministerQSE/Content/Sense_Depl...

or you could just empty your qvd's at the end of your script (you don't delete the files, but they remain empty) 

store [TableYouCreated] into [PathToTheQVDyouWantToEmpty]; 

[Anusha1430]

Thanks for your response.
Can you please give me the query to empty the QVD

[Anusha1430]

Thanks for your response.

I will check how to run that trigger.

[Vegar]

EmptyTable:

Load * inline [Empty table];

Store EmptyTable into FileNameToReplace.qvd (qvd);