archive

[#1]

hi all,

Could you suggest here

step 1

Once the report reloads everyday with new data for ex: from folder 2015.csv>>aug.csv file

Load the data into qvd.

For ex

Customers:

Load * fromm..csv

Products

Load * from ...csv

Store Customers into Customers '$(timestamp).qvd (qvd);
Store Products into Products '$(timestamp).qvd(qvd);

step 2

Check in the specific folder whether the QVD is created and filesize >0

if file size > 0 then

step 3

Delete or  move from the folder to ....some drive

[#2]

step 3.

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

[nagarjuna_kotha]

Hi Benny,

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

[maxgro]

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

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

[#5]

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

[maxgro]

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

trace $(vQVDExists);

[#7]

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

[maxgro]

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

[#9]

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

C:

[#10]

can u share the qvw u tested