topic Re: Dynamically reading excel sheets from a folder in QlikView

Dynamically reading excel sheets from a folder

Thu, 08 Jan 2015 07:59:12 GMT

Hi,

I want to read the excel files from a folder dynamically.If I entered a new data then it should read dynamically and produce output in the dashboard.

Re: Dynamically reading excel sheets from a folder

kiranmanoharrode — Thu, 08 Jan 2015 08:12:31 GMT

Hi Ramya,

It is possible to read the excel files from a folder dynamically, but the nominclature of the file and header of the data field must be standard in all files.

for ex. Files are named with BUD2014Nov.xls,BUD2014Dec.xls,BUD2015Jan.xls

and all headers must be same in all files (No of fields and title of the fields)

With above standards, it is easy to fetch data dynamically from single folder

Test:

Load *

From

D:\folder\BUD*.xls;

Regards,

Kiran

8976977897

Re: Dynamically reading excel sheets from a folder

datanibbler — Thu, 08 Jan 2015 08:12:51 GMT

Hi Ramya,

can you be a bit more explicit about your goal, please?

Reading new data dynamically is possible using QMC - just set the app to reload every xx minutes and new data will be loaded then - reloading as soon as there is data might be possible using an external trigger, but certainly not easy.

If what you want is reading new Excel_files when they pop up in the directory, you need a FOR_EACH loop.

HTH

Best regards,

DataNibbler

Re: Dynamically reading excel sheets from a folder

Thu, 08 Jan 2015 08:14:37 GMT

hi ramya,

if u entered new data to the existing files in excel or so called table then we have to add new records explicitly in qlikview with the help of date field. it is called incremental load.

Re: Dynamically reading excel sheets from a folder

Tue, 24 Feb 2015 08:08:29 GMT

Hi Kiran,

I have same issue with bit of different scenario -

I am receiving daily production report from the users in below format and file name.

"Production Report of jan.xls"

ID	Name	01/01/2015	01/02/2015	01/03/2015
1	a	10	90	20
2	b	20	46	30
3	c	30	45	98

I am going to get same format data for February also .

Here the problem is as per your code i can load all the excel file from a folder which is having same nomenclature and header but in my case first and second column will have the same header but from third column it won't as from here date is going to start.

I am using crosstable to making date as a field in Qlikview.

Please advise how can i resolve this issue.

Your help on this regard will be appreciated.

Thanks & regards,

Himanshu

Re: Dynamically reading excel sheets from a folder

Tue, 24 Feb 2015 08:39:01 GMT

You could write:

Load * FROM C:\Excels\*.xls (biff, embedded labels, table is [sheet_name$]);

Provided you have no ambiguity in the data field names. It is necessary that the column names should be same in every excel and the name of the sheet should also be the same in every excel file.