topic Re: Delete old rows from QVD in QlikView

Delete old rows from QVD

Tue, 21 Apr 2015 13:44:37 GMT

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 — Tue, 21 Apr 2015 13:49:07 GMT

I think u can use incremental load concept here.

mohamed_ahid — Tue, 21 Apr 2015 14:10:48 GMT

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