Qlik Community

Qlik Sense Documents & Videos

Documents & videos about Qlik Sense.

Incremental Load using Timestamps Multiple Excel

Champion
Champion

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

Attachments
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: