Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Hi,
Try suggested script from this topic:
http://community.qlik.com/forums/p/23999/91768.aspx
Or see 'Photo and Music' demo
Andris
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.
Do you perhaps have some sample code?