Qlik Community

Qlik Sense Enterprise Documents & Videos

Documents & videos about Qlik Sense.

Announcements
BARC’s The BI Survey 19 makes it official. BI users love Qlik. GET REPORT

Incremental Load using Timestamps Multiple Excel

vikasmahajan
Esteemed Contributor

Incremental Load using Timestamps Multiple Excel

Dear All,

Sharing incremental load using timestamps for Multiple Excels.

Logic of this script :

Step  1.  Will Pull Excels and create qvd ALLQVD.QVD for multiple excel files.

Step 2.   Will Check whether user is modified excels files if yes then script will mark flag as 1 and

                 delete the records from QVD and append fresh records from modified excels.

Step 3.   Script will check  whether there is new file available for upload if  yes then script will append the same.

For developing above script I take help from tresesco‌ ,  MayilVahanan‌ , sunindia ,pradeept

Thanks to all.

Vikas

Comments
Partner
Partner

thanks for sharing. good one

0 Likes
Version history
Revision #:
1 of 1
Last update:
‎2016-02-11 06:16 AM
Updated by: