topic Read excel from multiple subfolders in QlikView

Read excel from multiple subfolders

Fri, 29 Jan 2010 14:10:58 GMT

I am trying to read Excel files from multiple subfolders into QlikView. The only problem is I don't want to create multiple LOAD statments in the script and I do not always know the name of the subfolders.

The following load statement doesn't work. * should be a any subfolder in the folder

\\Severname\Folder\*\Sales.xls

Read excel from multiple subfolders

Fri, 29 Jan 2010 14:27:33 GMT

Hi,

Try suggested script from this topic:

http://community.qlik.com/forums/p/23999/91768.aspx

Or see 'Photo and Music' demo

Andris

Read excel from multiple subfolders

amit_shetty78 — Fri, 29 Jan 2010 15:13:06 GMT

Hi,

What I have done in one of my app is that I maintain a separate xls with the list of all the locations and in the load script load the data from all the file in a loop to pick up all the files from the different locations. The location and name of the file is stored in a variable that I use in my load statement

Hope this helps.

Amit.

Read excel from multiple subfolders

Fri, 29 Jan 2010 15:35:14 GMT

Do you perhaps have some sample code?