topic Re: List folders within a directory in Connectivity & Data Prep

List folders within a directory

thomas_evans — Tue, 30 Oct 2018 00:53:04 GMT

Hi All,

Haven't managed to find anything online which seems to work.

I have a folder lets say D:\Backup. Within that folder I have a series of folders, one for each day i.e. backup20180101, backup20180102 and so on. I am trying to write a script that will return the subfolder names into a single table. I know how to get this for the files contained within, but in this case I need the folder names.

Can anyone give any hints here, I have tried Directory and DoDir functions in a loop, but couldn't seem to get anything to work..

Thanks!!

Re: List folders within a directory

andrey_krylov — Tue, 30 Oct 2018 03:47:03 GMT

Hi Thomas. Maybe this

For each vSubDir in dirlist( 'D:\Backup\*' )

Table: LOAD '$(vSubDir)' as DirName AutoGenerate 1;

Next SubDirectory

Re: List folders within a directory

thomas_evans — Tue, 30 Oct 2018 21:24:44 GMT

Hi Andrey,

Ran the code, doesn't seem to return any results... ?

Re: List folders within a directory

andrey_krylov — Wed, 31 Oct 2018 02:16:19 GMT

Sorry Thomas, my mistake. Confused in the variables...

For each vSubDir in dirlist( 'D:\Backup\*' )

Table: LOAD '$(vSubDir)' as DirName AutoGenerate 1;

Next vSubDir

Re: List folders within a directory

Krishn — Tue, 14 Jan 2020 15:43:36 GMT

Hello

This also do not gives any result.

Regards

Krishn

Re: List folders within a directory

lachlanwcast — Thu, 05 Nov 2020 04:51:37 GMT

Hi there,

The script by andrey_krylov works for me - but perhaps may not always work if you have the default file system restriction switched on on the newer versions of Qlik.

Here is something from the Qlik website that may assist - Example 2: Creating a list of files on disk:

https://help.qlik.com/en-US/sense/April2020/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptControlStatements/For%20Each.htm

You can adjust this to load a list of folders by adding something like a subfield to the '$(File)'