topic Re: List from subfolders in QlikView

List from subfolders

AmCh — Wed, 18 Aug 2021 11:06:17 GMT

Hello all,

I want to create from the folder FolderA with path (N:\Dashboard\FolderA) a list with the subfolders of FolderA (also FolderA1, FolderA2,FolderA3).

The desired output then:

FolderA

FolderA1

FolderA2

FolderA3

Any help please?

Thanks in advance

Best regards

Re: List from subfolders

Vegar — Wed, 18 Aug 2021 11:34:34 GMT

You can create folders with qlikview by execute statements.

Try a script like this:

LET vRootPath = 'N:\Dashboard\FolderA\';
FOR each vSubFolder in 'FolderA1', 'FolderA2'
Execute cmd.exe /C mkdir $(vRootPath)&$(vSubFolder);
next vSubFolder

PS: you might need to adjust your settings to allow the script to run write and execute statements.

Re: List from subfolders

AmCh — Wed, 18 Aug 2021 11:42:30 GMT

Hi Vegar,

thank you for your prompt response.
I want actually to create a field from already existed FolderA.

FolderA exists with the path 'N:\Dashboard\FolderA'. Its subfolders exist as well and are FolderA1 and FolderA2.
I want just to create a field with the name FolderA and with field values FolderA1 and FolderA2.

Thank you in advance.

Re: List from subfolders

Vegar — Wed, 18 Aug 2021 12:03:53 GMT

Try this:

LET vRootPath = 'C:\Temp\FolderA\';

For each vSubFolder in DirList('$(vRootPath)*')
LOAD
Mid('$(vSubFolder)', 1+ len('$(vRootPath)')) as FolderA
AutoGenerate 1;
next vSubFolder

Re: List from subfolders

Amit — Mon, 09 Oct 2023 15:56:47 GMT

Perfect!