topic Re: Incremental load in QlikView

Incremental load

Wed, 05 Feb 2014 05:00:42 GMT

hi,

can any body send me executable incremental load based on modified date .the data has been changing by monthly and has

deletion of rows is also there.

regards

Mahesh T

Re: Incremental load

Wed, 05 Feb 2014 05:11:35 GMT

SET QVDFILE=$(MyQvd)\QVDNAME.qvd;

TABLENAME:
SQL SELECT *
FROM SIEBEL." TABLENAME" WHERE to_char(LAST_UPD,'YYYYMMDD') >='$(vLastReloadTime)';

IF FileSize('$(QVDFILE)') > 0 THEN

TABLENAME _1:
LOAD DISTINCT
*
,ROW_ID As PK
RESIDENT TABLENAME;

DROP TABLE TABLENAME;

CONCATENATE (TABLENAME_1)

LOAD * FROM $(QVDFILE) (qvd)
WHERE NOT exists(PK, ROW_ID)
;

DROP FIELD PK;

STORE TABLENAME_1 INTO $(QVDFILE);

DROP TABLE TABLENAME_1;

ELSE

STORE TABLENAME INTO $(QVDFILE);

DROP TABLE TABLENAME;

END IF

Re: Incremental load

Wed, 05 Feb 2014 05:21:00 GMT

function used for $(vLastReloadTime)

Re: Incremental load

sundarakumar — Wed, 05 Feb 2014 05:53:46 GMT

It should be

=ReloadTime()

-Sundar

Re: Incremental load

Wed, 05 Feb 2014 06:16:41 GMT

Let vLastReloadTime = Date(vLastReloadTime-2,'YYYYMMDD');

Re: Incremental load

Anonymous — Mon, 16 Jun 2014 05:13:29 GMT

Hi Venkata Reddy,

Please attach me the Sample QVW file .

This will help you a lot ..