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
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