how to append and delete data in QVD

[#1]

hi

i am loading daily data from Excel as today's date

Load

.

.

.

from

file

i want to save daily file in a qvd. So after a week , this qvd will have 7 days data

on the 8th day, i want to delete last 5 days data from the same qvd

please advise

thanks

[kaushiknsolanki]

Hi,

     Try something like this.

     if day(today()) = 8 then

          TB1:

          Load * from abc.qvd where date >= today()-3;

          Store TB1 into abc.qvd;

     Else

          Other script.

     End if

Regards,

Kaushik Solanki

[#3]

thanks for that

but  to append data in same qvd for multiple days, it is not working

for eg

day 1 i hit load button

Load

.

.

.

from file

store file into qvd

day 2 i hit load button

load

.

.

.

from file

store file into qvd

-----Day 1 data gets overwritten and i only see Day 2 data in qvd

any advise

thanks

[#4 · Accepted solution]

To append you need load the original QVD first, then concatenate the lastest data and store it into same QVD.

Ex:

LOAD * from Ex.qvd

concatenate

Load

.

.

from day2_data;

store Ex into Ex.qvd (QVd);

Hope this help.

Regards,

Amay

[kaushiknsolanki]

Hi,

     tell me what exactly you want to do after 7 days.

     After 7 days you want only last 3 days data?

     if not then kindly explain with example.

Regards,

Kaushik Solanki

[#6]

hey Amay and Kaushil

thats for your help

i will merge your solutions to get what i want

cheers