topic Re: Delete & Load -30 Days Data in QlikView

Delete & Load -30 Days Data

Sun, 22 Mar 2015 09:05:09 GMT

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

Re: Delete & Load -30 Days Data

Gysbert_Wassenaar — Sun, 22 Mar 2015 09:42:18 GMT

MyTable:

LOAD *

FROM MY_FACT.QVD (qvd)

WHERE TRX_DATE < today()-30;

STORE MyTable IN MY_FACT.QVD;

Re: Delete & Load -30 Days Data

Sun, 22 Mar 2015 09:45:52 GMT

Hi Gysbert,

thanks for the reply .

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

Re: Delete & Load -30 Days Data

simsondevadoss — Sun, 22 Mar 2015 11:23:25 GMT

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

Re: Delete & Load -30 Days Data

jpitfield — Sun, 22 Mar 2015 12:27:31 GMT

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;