topic Re: dynamically reading excel files in QlikView

dynamically reading excel files

Thu, 24 Dec 2015 05:07:12 GMT

i have a scenario :

there are some excel files wsr (weekly status reports) generated on every monday and are loaded on sharepoint site ,

my requirement is that qlikview should directly read the files from the sharepoint path and according to that generate report ,and the new files contains the new data along with the old data (of orevious week as well)

so logic should be written accordigly,

kindly help and guide for the same.

Re: dynamically reading excel files

Anonymous — Thu, 24 Dec 2015 05:39:31 GMT

It would be same excel file with updated data or different file??

Re: dynamically reading excel files

Anonymous — Thu, 24 Dec 2015 05:41:29 GMT

check this as well:

Loading Multiple Excel Sheets Dynamically along with file name and sheet name

Load multiple excel files from Multiple excel sheetsinto QV

Load Multiple excel sheets using For loop

Re: dynamically reading excel files

ajsjoshua — Thu, 24 Dec 2015 05:42:33 GMT

hi,

Try with qlikview optimization

Re: dynamically reading excel files

Thu, 24 Dec 2015 05:43:55 GMT

same excel file with just date changed

Re: dynamically reading excel files

Anonymous — Thu, 24 Dec 2015 07:42:58 GMT

Okay, you mean to say new Fileds as well?

or same column with new data?

Re: dynamically reading excel files

Anonymous — Thu, 24 Dec 2015 07:48:04 GMT

If it is , same field with new data...

Then it is QV basis functionality, make the connection once in QV..

Then schedule it eithrt at QMC or by Batch File, every time on reloads it will automatically fetch the updated data.

Is this you are asking?

Re: dynamically reading excel files

Anonymous — Thu, 24 Dec 2015 08:00:47 GMT

check this, hope you will get your answer:

How to get updated new fields data into qlikview without editing the script manually

Refreshing Excel data tables before a load

Loading Excel file with data in Qlikview automatically

Re: dynamically reading excel files

vikasmahajan — Thu, 31 Dec 2015 05:33:03 GMT

Dear Shivali,

Please find this thread Load excel files dynamic and check whether excel file is changed or modify if yes load into qvd‌

In this thread Kush has answered my question which will full fill your requirement.

Vikas

Re: dynamically reading excel files

HirisH_V7 — Thu, 31 Dec 2015 09:10:20 GMT

Hi ,

One thing if the all the headers in each and every excel file in that folder .You can fetch them by,

AllTablesData:
Load *

From
[FolderPath\*.xls]

Your data will be fetched daily.if you run the application on Daily Basis on QMC or thorugh your Batch file like this,

https://community.qlik.com/docs/DOC-8899

HTH,

Hirish