topic Recursive filelist in QlikView

Recursive filelist

Tue, 15 Sep 2009 02:01:55 GMT

I'm trying to change the following line in the script so that it not only looks in My Pictures but also in all the subdirectories of My Pictures. Any ideas how I would go about this?

for each vFoundFile in filelist( GetFolderPath('MyPictures') & '\*.'& vExt )

Many thanks. Paul

Recursive filelist

prieper — Tue, 15 Sep 2009 02:34:44 GMT

Hi,

am not aware on a specific switch. It might be cumbersome, but found a solution under
http://vbnet.mvps.org/index.html?code/fileapi/oldestfolder.htm
from where you might grab an idea.

HTH
Peter

Recursive filelist

Tue, 15 Sep 2009 03:00:56 GMT

with a little modification this should help

http://community.qlik.com/wikis/qlikview-wiki/loading-data-from-multiple-xls-files-from-folder-with-subfolder.aspx

Recursive filelist

Tue, 15 Sep 2009 03:22:00 GMT

Thanks, I managed to work it out using the "for each...next" section of the Help. But beware if you copy and paste the example code for sub DoDir, as it adds a space before the \* and doesn't work! Took me a good half hour to find out why it wasn't working, but now it works a treat.

Recursive filelist

Tue, 15 Sep 2009 04:08:28 GMT

that's odd, I used that code to look for a specific file in N subdirectories, and apart from changing the root and file extension, it worked perfectly.