Qlik Community

QlikView Scripting

Discussion Board for collaboration on QlikView Scripting.

Announcements
QlikView Fans! We’d love to hear from you.
Share your QlikView feedback with the product team… Click here to participate in our 5-minute survey.
Rules, plus terms and conditions, can be found here.
Not applicable

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

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.

1 Solution

Accepted Solutions
Not applicable

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

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:')

2 Replies
Not applicable

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

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:')

Not applicable

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

Thank you! It worked.

Community Browser