Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dear Team ,
I have 12 files like AssetTrackingAug1.xlsx , AssetTrackingSep1.xlsx , AssetTrackingOct1.xlsx ,etc .
1. I want to load this dynamically and save it into QVD.
2. if AssetTrackingAug1.xlsx file modified later then this should pickup for loading
Thanks
Vikas
Hi Vikas,
Please find the updated application which works for me with the scenario I have mentioned in my above post
Hi,
Maybe this would be helpful to you.....
Load multiple excel files from Multiple excel sheetsinto QV
Regards,
Bhavini S Mehta.
How would you track the change in file?
we load file name with date into qvd like Filename_QVD_History.QVD and check it with new file ?
Vikas
I want to load hole file again by doping old if date is changed
Vikas
Hi,
I think you need to apply Incremental load (Insert, Update and Delete) for this.
Below is the link which might help you:
http://www.analyticsvidhya.com/blog/2014/09/qlikview-incremental-load/
And For loading Multiple Excels this would be useful.....
Load multiple excel files from Multiple excel sheetsinto QV
Regards,
Bhavini S Mehta.
Dear All,
I have created qvw file for the same but needs some improvements
Vikas
I think you need to append the Timestamp when file gets modified for eg Filenanme_2015-12-17 12:00:00 so that we can load the timestamp from filename & compare it with filename again.
yes you are right and and after comparing it should take new excel sheet data. Can you help to get the same with qvw.
Vikas
Vikas