topic How to load directory structure (without files) into inline data table? in QlikView

How to load directory structure (without files) into inline data table?

Mon, 25 Jul 2011 08:05:09 GMT

Heres what I'd like to do:

Get a directory structure (using "For each Dir in dirlist(Root&'\*')") and load it in a QV table.

Can someone help me with a syntax?

Thanks.

Arunas T.

Mon, 25 Jul 2011 08:29:31 GMT

try this:

sub DoDir (Root)

load '$(Root)' as DirName

autogenerate 1;

for each Dir in dirlist ('$(Root)\*' )

call DoDir (Dir)

next Dir

end sub

call DoDir ('D:')

Mon, 25 Jul 2011 08:47:38 GMT

Thank you! It worked.