topic Re: drop qvd in QlikView

drop qvd

Tue, 18 Nov 2014 10:41:22 GMT

Hello,

I am very new to Qlikview, can someone tell me how can i drop the qvd file using the script before loading the data on it.

Thanks in advance.

Re: drop qvd

Tue, 18 Nov 2014 13:44:54 GMT

qvd is nothing but a table

drop table tablename; here tablename is the qvd name which u have given

Re: drop qvd

Anonymous — Tue, 18 Nov 2014 14:17:36 GMT

If you want to delete the qvd from the folder

below is the code

vTempQVDPath = GetFolderPath()//Path of the QVD
EXECUTE cmd.exe /C del $(vTempQVDPath)\*.qvd;

you need ensure that "Can execute external programs" in script window

Regards

Harsha

Re: drop qvd

maleksafa — Tue, 18 Nov 2014 14:21:58 GMT

if you just one to empty the qvd before loading new data in it, then there is no need to delete it, when loading data from a table into a qvd it will override the existing information.

Re: drop qvd

Tue, 18 Nov 2014 15:16:46 GMT

Hi,

If you want to drop qvd which store table you can use

Drop table Qvd_tablename;( which table qvd creates)

or else if you want to delete the qvd from specified path use this

Execute cmd.exe /c del C:/file.qvd;

delete qvd's from folder by scirpt

Re: drop qvd

Wed, 19 Nov 2014 03:40:02 GMT

Hi All,

Thanks for your help.

I am trying to exetute the following command from my script but not able to delete the below qvd file.

Execute cmd.exe /c del D:\Abdul Kaleem\Qlikview testing\qvd\test_load.qvd

let me know if any changes required in the command.

Thanks!

Re: drop qvd

michael_anthony — Wed, 19 Nov 2014 03:51:09 GMT

Try Execute cmd.exe /c del "D:\Abdul Kaleem\Qlikview testing\qvd\test_load.qvd";

Need quotation marks around the file name or else the spaces confuse cmd.exe statement.

Re: drop qvd

Wed, 19 Nov 2014 04:02:37 GMT

Hello Michael,

still not able to delete the file.

Re: drop qvd

michael_anthony — Wed, 19 Nov 2014 04:04:02 GMT

What happens when you run the script?

Re: drop qvd

jagan — Wed, 19 Nov 2014 04:18:31 GMT

Hi,

Generally in Qlikview QVDs are not deleted, everytime we will replace the existing QVDs not sure why you are trying to delete the QVD from Qlikview.

This is not a good practice, instead you can create a windows job to do this periodically.

Hope this helps you.

Regards,

Jagan.

Re: drop qvd

Wed, 19 Nov 2014 04:19:45 GMT

it opens the cmd.exe window and it is waiting for the input.

Re: drop qvd

Wed, 19 Nov 2014 04:31:52 GMT

Hi Jagan,

We are palnning to housekeep the qvd files periodically, every day when our batch runs it will create a seperate QVD file with a date stamp in the file name.

So we need to maintain only last 10 days files in the QVD folder, files which are older than 10 days needs to purged.

For example when running the batch for 19-Nov need to purge any qvd files which are generated before 9-Nov.

Thanks,

Abdul Kaleem

Re: drop qvd

michael_anthony — Wed, 19 Nov 2014 04:33:23 GMT

Strange, I did a quick test and it deletes okay and closes the window. Can you post the part of the script using to delete

Re: drop qvd

jagan — Wed, 19 Nov 2014 04:58:20 GMT

Hi Abdul,

Create a windows scheduler job for this instead of managing this in Qlikview.

Regards,

Jagan.

Re: drop qvd

Wed, 19 Nov 2014 06:20:13 GMT

Execute cmd.exe \c del "D:\Abdul Kaleem\Qlikview testing\MAS613_dataload_3.qvd";

Re: drop qvd

michael_anthony — Wed, 19 Nov 2014 06:24:49 GMT

Use Execute cmd.exe /c

You have the /c with a \.

Re: drop qvd

Wed, 19 Nov 2014 06:47:40 GMT

Thanks Michael!

It works now.. Thanks to all for sharing their commands and views.