Code to delete qvd in the load script . Help please ?

[prahlad_infy]

Hello Sirs ,

How to delete qvd at a particular location ?

Attached is sample file .

[swuehl]

Maybe have a look at one of the proposed solutions here:

QlikTip #30: How to delete existing QVD files via load-script

[prahlad_infy]

did not work

[prahlad_infy]

[swuehl]

The /C option should not be part of your path. You may also need to use quotes if your path contains white spaces.

[kfoudhaily]

in order for this command to work you need to authorise qlikview to execute external programs;

to do this, go to scripting page and then settings:

Can you tells us why you need to delete it if it does not worth storing?

you may simply load table2 directly no?

else you use "noconcatenate" command

[prahlad_infy]

Sorry , do you mean this ; -> EXECUTE cmd.exe 'C:\Users\44099479\Desktop\Delete QVD' del Table1.qvd ;

Now i am getting the CMD automatically opened and it keeps on waiting , till i close cmd prompt . And when i close it script windows stops and ask for reload of old data .

Can you please attach a sample qvw ;

[kfoudhaily]

yes, bacause qlik doesn't know if cmd has done execution or not.

here is a bette solution:

in your script put this: EXECUTE C:\Users\...\Desktop\DEL.bat

create batch file and put the following inside:

@echo off

cls

del /Q C:\Users\...\Desktop\chantier_cuisine_ar.qvd

exit

regardsn