Discussion Board for collaboration related to Creating Analytics for QlikView.
I'm looking for some solution to ready multiple folders as data source (txt or excel)
Basically I need to create a load statement where I ready from all the folders below?
Folder 1\SubFolder 1
Folder 1\SubFolder 2
Folder 1\SubFolder 3
inside the folder I have a generif file name it means I should read all files with .xls extension
Thanks in advance,
Go to Solution.
Look at help, 'foreach' statement. There is an example.
take a look at below script, this might help you.
SUB doDir (dir)
FOR EACH file in filelist('$(dir)' & '\*.qvw')
FOR EACH subdir in dirlist( '$(dir)' & '\*' )
FOR EACH subdir in dirlist( '.' & '\*' )