Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join this live chat April 6, 10AM EST - QlikView to Qlik Sense REGISTER
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Incremental load

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

5 Replies
Not applicable
Author

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

Not applicable
Author

function used for $(vLastReloadTime)

sundarakumar
Specialist II
Specialist II

It should be

=ReloadTime()

-Sundar

Not applicable
Author

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

venkatasreekant
Specialist
Specialist

Hi Venkata Reddy,

Please attach me the Sample QVW file .

This will help you a lot ..