Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
prahlad_infy
Creator
Creator

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

Hello Sirs ,

How to delete qvd at a particular location ?

Attached is sample file .

Screen Shot.jpeg

7 Replies
swuehl
MVP
MVP

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

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

prahlad_infy
Creator
Creator
Author

did not work

Screen Shot (2).jpeg

prahlad_infy
Creator
Creator
Author

Screen Shot 20.jpeg

swuehl
MVP
MVP

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

kfoudhaily
Creator III
Creator III

Capture.PNGin 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
Creator
Creator
Author

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 ;

Delete.png

kfoudhaily
Creator III
Creator III

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