Solved: Re: Load excel files dynamic and check whether exc... - Qlik Community

vikasmahajan · ‎2015-12-18

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Kushal_Chawda · ‎2015-12-20

Hi Vikas,

Please find the updated application which works for me with the scenario I have mentioned in my above post

View solution in original post

Anonymous · ‎2015-12-18

Hi,

Maybe this would be helpful to you.....

Load multiple excel files from Multiple excel sheetsinto QV‌

Regards,

Bhavini S Mehta.

Kushal_Chawda · ‎2015-12-18

How would you track the change in file?

vikasmahajan · ‎2015-12-18

we load file name with date into qvd like Filename_QVD_History.QVD and check it with new file ?

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

vikasmahajan · ‎2015-12-18

I want to load hole file again by doping old if date is changed

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Anonymous · ‎2015-12-18

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.

vikasmahajan · ‎2015-12-18

Dear All,

I have created qvw file for the same but needs some improvements

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Kushal_Chawda · ‎2015-12-18

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.

vikasmahajan · ‎2015-12-18

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

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

vikasmahajan · ‎2015-12-18

maxgro‌ Can you please help to achieve the same

Vikas

Hope this resolve your issue.
If the issue is solved please mark the answer with Accept as Solution & like it.
If you want to go quickly, go alone. If you want to go far, go together.

Load excel files dynamic and check whether excel file is changed or modify if yes load into qvd

maxgro‌ Can you please help to achieve the same