topic Re: Delete xls files in QlikView

Delete xls files

Tue, 10 Nov 2015 17:08:14 GMT

Hi All.

I have a scenario with multiple xls files to load in QV. After the full load, the end user only want to charge the most recent file and delete the others. Can I automatically remove them since QV? I have already identified the most recent file, I just need to clarify if the rest of the files can be removed directly from QV.

Thanks for your attention.

Re: Delete xls files

swuehl — Tue, 10 Nov 2015 19:00:48 GMT

You can run windows command line commands from within the load script, have a look at EXECUTE in the Help.

The QV script line looks like

Execute cmd.exe /C "D:\YOURPATH\script.bat";

Instead of a batch file, you can call other windows commands, like DEL.

You may need to allow the script to execute in script editor -> settings.

Re: Delete xls files

maxgro — Tue, 10 Nov 2015 19:05:36 GMT

FOR each _vsFile in 'a.xls', 'b.xls'

SET _vsBatch = 'cmd.exe /C del "$(_vsFile)" /Q';

trace $(_vsBatch);

EXECUTE $(_vsBatch);

NEXT;

Re: Delete xls files

Tue, 10 Nov 2015 20:54:30 GMT

Thank's for your answers.

I tried using this syntax, but QV execute the cmd.exe instead of script.bat.

In QV:

EXECUTE cmd.exe C/ C:\script.bat;

The script.bat is simple:

DEL /P "C:\Hola Mundo.txt"

Any ideas?

Re: Delete xls files

swuehl — Tue, 10 Nov 2015 22:16:24 GMT

Not yet, worked ok for me:

EXECUTE cmd.exe /C DEL /P "C:\Temp\test.txt";

Re: Delete xls files

Wed, 11 Nov 2015 11:56:48 GMT

Thank's... It's working now.