topic Re: Delete files with script in QlikView

Delete files with script

Anonymous — Wed, 25 Nov 2020 16:16:04 GMT

Is it possible to delete files using the script?

I have an scrip that loads a file and the makes use a store to save the outcome as a new file, but noticed that If I run this is script and the file is already saved on the folder the script stop triggering some erro message. When I delete the file manually, and run the script again everything works fine. So I wonder if I can add some kind of DELETE function at the beginning to be sure no previous files are present in the folder.

Does it make sense?

Re: Delete files with script

micheledenardi — Thu, 01 Jun 2017 09:29:13 GMT

You can use Execute statement to run batch file which can delete the file.

Re: Delete files with script

prieper — Thu, 01 Jun 2017 12:14:54 GMT

and the (technical) user executing the script must have write/delete priviliges.

Re: Delete files with script

Peter_Cammaert — Thu, 01 Jun 2017 12:26:13 GMT

And the user must also be allowed to run external programs

Re: Delete files with script

Peter_Cammaert — Thu, 01 Jun 2017 12:30:36 GMT

An extensive treatment by Stefan Walther of multiple options to delete files is provided here: QlikTip #30: How to delete existing QVD files via load-script