Qlik Community

Ask a Question

QlikView App Dev

Discussion Board for collaboration related to QlikView App Development.

Announcements
Join us at the Cloud Data and Analytics Tour! REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
Not applicable

Read excel from multiple subfolders

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

3 Replies
Not applicable
Author

Hi,

Try suggested script from this topic:

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

Or see 'Photo and Music' demo

Andris

amit_shetty78
Creator II
Creator II

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.

Not applicable
Author

Do you perhaps have some sample code?