Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW

Load only new or updated excel files dynamically

cancel
Showing results for 
Search instead for 
Did you mean: 
Kushal_Chawda

Load only new or updated excel files dynamically

Last Update:

Sep 20, 2022 1:59:53 PM

Updated By:

Sue_Macaluso

Created date:

Jan 10, 2016 12:28:53 PM

Attachments

In my below post, there is a method to load all the excel files dynamically . We will use the same subroutine here as well to  create the QVD from all the excel files.

Dynamically Loading Multiple Excel Files

Once the QVD is created by loading all the excel files there could be the possibility of two requirements

1) Load only newly arrived excel file in the folder instead of loading all the excel files again.

2) Load only updated excel files in the folder instead of loading all the excel files again.


If the number of excel files are less and the amount of data is also less then we can directly load all the excel file for each reload to create the QVD but if the condition is opposite then we can use the above approach


Below is the simple algorithm to load new or updated excel file

1) First create the QVD from all the excel files available in the folder ( for eg A.qvd)

2) Check if there is new excel file available when performed next reload.

3) If new file is not available then print "New file not available"

4) If new excel file is available then load only the new excel file and append with the A.qvd which was created in step 1 (New excel+ A.qvd)

5) Store the data from step 4 into the A.qvd

6) Check if any file is updated or not. If file is updated then load only updated file from excel & load the remaining data from A.qvd which was created in step 5.

7) Store the data from step 6 into the A.qvd

😎 If file is not updated then print "No updated file available".

Note- First we will check for new excel file and then we will be going to check the updated files.


Please find the attached QVW file which demonstrates the above algorithm. You can test the script with the excel files attached in the post mentioned above.


Regards,

Kushal Chawda

Tags (1)
Labels (1)
Comments
manojkulkarni
Partner - Specialist II
Partner - Specialist II

Great. Thanks for sharing application

Anonymous
Not applicable

Nice..

rmuhammad
Creator
Creator

Thanks very useful article. This is what i was looking for.

Not applicable

Useful Article Kushal. Thanks a lot

Version history
Last update:
‎2022-09-20 01:59 PM
Updated by: