Load only newly arrived or updated excel files dynamically

[Kushal_Chawda]

In the post below, I’ve shared a method to dynamically load all Excel files. We’ll use the similar subroutine here to create QVDs from all the Excel files.

Dynamically Loading Multiple Excel Files

Once the QVD is created by loading all the Excel files, two potential requirements may arise:

1. Load only newly arrived Excel files in the folder, instead of reloading all the files.
2. Load only updated Excel files in the folder, instead of reloading all the files.

If the number of Excel files and the amount of data are small, you can reload all the files each time to create the QVD. However, if the files or data are large, the above approach can be used to optimize the process.

Please find the attached QVW file.

Note: This script is best suited for QlikView

Regards,

Kushal Chawda

[manojkulkarni]

Great. Thanks for sharing application

[Anonymous]

Nice..

[rmuhammad]

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

[#5]

Useful Article Kushal. Thanks a lot