Qlik Community

QlikView App Development

Discussion Board for collaboration related to QlikView App Development.

vikasmahajan
Honored Contributor III

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

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

1 Solution

Accepted Solutions

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

Hi Vikas,

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

18 Replies
bhavinimehta
New Contributor III

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

Hi,

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

Load multiple excel files from Multiple excel sheetsinto QV

Regards,

Bhavini S Mehta.

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

How would you track the change in file?

vikasmahajan
Honored Contributor III

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

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

Vikas

vikasmahajan
Honored Contributor III

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

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

Vikas

bhavinimehta
New Contributor III

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

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
Honored Contributor III

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

Dear All,

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

Vikas

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

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
Honored Contributor III

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

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

vikasmahajan
Honored Contributor III

Re: 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

Vikas

Community Browser