topic Re: execute cmd delete from script in QlikView

execute cmd delete from script

ssriramin19 — Tue, 20 Nov 2018 06:07:10 GMT

Hello Everyone,

The excel file needs to be deleted from the share path , so I am writing the execute command. But file is not getting deleted .

This is the execute command

EXECUTE cmd.exe /C Del "\\SESKWQVPPD01\QlikView\SourceDocs\Otif\PreProduction\1_Source_Data\RCA\$(vFile).xls";

Can anyone please suggest me what is wrong & what is the syntax for execute command to delete the excel file from the script

Thanks - Sriram

Re: execute cmd delete from script

ssriramin19 — Tue, 20 Nov 2018 06:34:47 GMT

Can any one please help me on this delete file from a folder

Re: execute cmd delete from script

punitpopli — Tue, 20 Nov 2018 06:50:02 GMT

Check if your variable is populating correctly.

if not then try to break the path, file name and file extension, this should work.

Re: execute cmd delete from script

ssriramin19 — Tue, 20 Nov 2018 07:13:14 GMT

Even When I tried to delete excel file from my local system , I am getting following error
EXECUTE cmd.exe/C Del "C:\Users\kglt280\Documents\requirements_2\New folder (8)\Vietnam RCA Template.xlsx";

Can anyone please help me on this on how to resolve the error ?

Please suggest

Re: execute cmd delete from script

punitpopli — Tue, 20 Nov 2018 07:19:52 GMT

check if you had read write permission on the folder you are performing action

Re: execute cmd delete from script

ssriramin19 — Tue, 20 Nov 2018 08:31:19 GMT

Will execute command work in QV version 12 ? I am unable to perform the delete the file using execute command in version 12 .

The Cmd.exe/C Del "\\ file name" works properly in CMD .
Please suggest

Re: execute cmd delete from script

punitpopli — Tue, 20 Nov 2018 09:48:46 GMT

check if below setting are enables in your system