Delete & Load -30 Days Data

[#1]

Hi,

I want to delete (TRX_DATE) >= TRUNC (SYSDATE - 30) data from my .QVD , then load (TRX_DATE) >= TRUNC (SYSDATE - 30) data back .

how can i achieve this using the below tables :

FACT:
SQL SELECT TRX_DATE , VALUE
FROM "FACT_TABLE";

STORE FACT INTO C:\Users\test\Documents\Qlik\MY_FACT.QVD;

Regards,

Adil

[Gysbert_Wassenaar]

MyTable:

LOAD *

FROM MY_FACT.QVD (qvd)

WHERE TRX_DATE < today()-30;

STORE MyTable IN MY_FACT.QVD;

[#3]

Hi Gysbert,

thanks for the reply .

I wanted to update my QVD with 30 days data , delete sysdate-30 n then load it again .

[simsondevadoss]

Use incremental load. Insert , update and delete only the past 30 days data

[jpitfield]

Some thing like this:

FACT:

Load

TRX_DATE ,

VALUE;

SQL SELECT TRX_DATE , VALUE
FROM  FACT_TABLE
Where TRX_DATE >=TODAY-30;
Concatenate
LOAD *
FROM MY_FACT.QVD (qvd)
WHERE TRX_DATE < today()-30;

STORE FACT INTO C:\Users\test\Documents\Qlik\MY_FACT.QVD;