Skip to main content
Woohoo! Qlik Community has won “Best in Class Community” in the 2024 Khoros Kudos awards!
Announcements
Nov. 20th, Qlik Insider - Lakehouses: Driving the Future of Data & AI - PICK A SESSION
cancel
Showing results for 
Search instead for 
Did you mean: 
Sxbbb
Creator III
Creator III

I want to load all folders

I want to load all folders.

Sxbbb_2-1687403959443.png

 

Inside the folder is an excel file.

Sxbbb_1-1687403841467.png

I tried the code but Error

Sxbbb_3-1687403998722.png

I want to load all folders

Labels (4)
1 Solution

Accepted Solutions
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

5 Replies
rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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
Creator III
Creator III
Author

If the folder keeps adding new folders what to do

rwunderlich
Partner Ambassador/MVP
Partner Ambassador/MVP

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

-Rob

Sxbbb
Creator III
Creator III
Author

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

Sxbbb
Creator III
Creator III
Author

The folder address comes from the SharePath.