I want to load all folders

[Sxbbb]

I want to load all folders.

Inside the folder is an excel file.

I tried the code but Error

I want to load all folders

[rwunderlich · Accepted solution]

You'll want to a loop 

for each dir in dirlist('xyz')

as shown here https://help.qlik.com/en-US/sense/May2023/Subsystems/Hub/Content/Sense_Hub/Scripting/ScriptControlSt...

-Rob

[Sxbbb]

If the folder keeps adding new folders what to do

[rwunderlich]

The code is dynamic.  Each time it runs it will find all folders.

-Rob

[Sxbbb]

I don't understand what type of code do I need? I read and didn't understand.

[Sxbbb]

The folder address comes from the SharePath.