Delete old rows from QVD

[#1]

Hi All,

I have a table that includes the following fields:

[collection_name],

[step],

[last_local_date_time]

[transactions_left]

the fields last_local_date_time and transactions_left are updated almost every 30 minutes.

I want to create a new qvd that will save the data every 20 minutes (so I could also see the history of the table)

I also want that old recorded will be deleted from the qvd (the qvd should contain data from the last 60 days).

can someone please advise? hope I was clear enought.

thanks

[buzzy996]

I think u can use incremental load concept here.

[mohamed_ahid]

Hello

if you want to keep the history of your QVD , every 20 min  :

table temp 1 :

load all fileds and datas from your Table .

concatenate those from yout QVD .

and then store all on QVD .

evry 20 min you will have new lines inserted in the QVD .

Other way is to create a new QVD for every load and whil storing give the same name concatednated with the load Datetime .

for the second point :

its juste a load from your qvd with a filtering of creation date (you can add a field of creation for every line )

hope its clear