Qlik Community

Qlik Sense Enterprise Documents & Videos

Documents & videos about Qlik Sense.

Announcements
Qlik® Product Spotlight: Discover what’s possible. Get more from our products.
See for yourself. Register today.

Incremental Load using Timestamps Multiple Excel

vikasmahajan
Not applicable

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
manojkulkarni
Not applicable

thanks for sharing. good one

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