Discussion board where members can get started with QlikView.
I need some help. One of my upcoming projects consits a large quantity of files.
They have all the same format, but the number of files indefinit yet.
Maybe thousands in one folder. I think that I can load it with the help of a loop.
Does anyone know how I can determine the file name and read the data accordingly?
Thanks for your help!
If the files have all the same format you could load the files with a wildcard for the filenames. If not and/or you need to apply something then you could use dirlist/filelist to read all available / needed files from your storage, like:
Loop through Folders and sub folders to get file names
use the function
Filename() gives the filename of the file loaded with extension
Filebasename() gives the only the file name without extenion
You can add these two functions in the script;
filename() as Filename
Filebasename() as Filebaase, // followed by field names