topic archive in QlikView

Re: archive

Wed, 23 Sep 2015 06:48:03 GMT

step 3.

Delete the folder 2015.csv or move or archive..

Re: archive

nagarjuna_kotha — Wed, 23 Sep 2015 06:55:03 GMT

Hi Benny,

I not understanding what exactly u want. can u explain it more ?

Re: archive

maxgro — Wed, 23 Sep 2015 06:59:29 GMT

if you want to delete, move, copy, in short execute dos commands from QlikView

Q-Tip #7 – Execute a Command Using EXECUTE | Natural Synergies

Re: archive

Wed, 23 Sep 2015 07:04:02 GMT

hi nagarjuna,

I would like to check whether the qvd is created 2. whether the qvd file size >0 .if yes --> delete the main folder

Re: archive

maxgro — Wed, 23 Sep 2015 07:10:36 GMT

let vQVDExists = if(len(FileSize('yourqvdfile.qvd')) > 0, -1, 0);

trace $(vQVDExists);

Re: archive

Wed, 23 Sep 2015 07:24:27 GMT

hi maxgro,

when iam trying to execute the command statement. it is in default going to the folder where the qvw is stored and does not consider the execute command

for ex ..I was testing the below

EXECUTE cmd.exe /C del "C:\Files\*.csv";

when I run the report ..the command prompt opens and it shows the path where the qvw is their as below

C:\Report\QVWs - here is where my qvw is stored. it does not identify the execute path

Re: archive

maxgro — Wed, 23 Sep 2015 07:33:02 GMT

I tried this, .qvw is in a different folder

EXECUTE cmd.exe /C del "C:\temp\test*.log";

and it works without any prompt when I reload

Re: archive

Wed, 23 Sep 2015 07:47:17 GMT

hi maxgro.

it is executing the command ..but it is not executing in the path I mentioned in the script..

it opens the cmd.exe and blinks

Re: archive

Wed, 23 Sep 2015 07:48:53 GMT

can u share the qvw u tested

Re: archive

maxgro — Wed, 23 Sep 2015 08:10:29 GMT

yes but it's just 1 line

create some file (C:\temp\test*.log)

and run it

Re: archive

Wed, 23 Sep 2015 08:20:00 GMT

hi maxgro I got it right ..for me the command should be like this..its working in this way

Execute cmd /C del /Q "filepath\filename";

secondly can u tell me if fileexists is a file with timestamp how can I check for ex: products20151210.csv..so I need to check only that file.. not older files

ex:products20151210.csv..

products20151110.csv..

products20151010.csv..

Re: archive

maxgro — Wed, 23 Sep 2015 11:50:11 GMT

let d=date(today()+18, 'YYYYDDMM'); // replace +18 with your logic, which is the date you want to test? today?

trace $(d);

let vQVDExists = if(len(FileSize('c:\temp\Products$(d).qvd')) > 0, -1, 0);

trace $(vQVDExists);

Re: archive

Wed, 23 Sep 2015 12:04:53 GMT

maxgro.. just to understand if multiple qvd files in a day

for products then for customers ..etc .can I add in the same below line customers also?

let vQVDExists = if(len(FileSize('c:\temp\Products$(d).qvd')) > 0, -1, 0);

Re: archive

maxgro — Wed, 23 Sep 2015 12:31:33 GMT

if you have multiple qvd (or csv) files and you want to check every file

you need to repeat the check (1 for Products, 1 for Customer, etc...........)

to check for Products and Customers of yesterday (if the reload run today)

let d=date(today()-1, 'YYYYDDMM');

let vQVDExistsProducts = if(len(FileSize('c:\temp\Products$(d).qvd')) > 0, -1, 0); // .qvd or .csv

// .... some code maybe using QVDExistsProducts

let vQVDExistsCustomers = if(len(FileSize('c:\temp\Customers$(d).qvd')) > 0, -1, 0);

// .... some code on Customers file

Re: archive

Wed, 23 Sep 2015 12:50:54 GMT

this is maxgro..thanks

Re: archive

Wed, 23 Sep 2015 12:51:37 GMT

this is good maxgro: thanks