Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Join us to spark ideas for how to put the latest capabilities into action. Register here!
cancel
Showing results for 
Search instead for 
Did you mean: 
sona_sa
Creator II
Creator II

Fetch Data From Folder and Subfolder

I have some xls file in Folder Structure Like :

lib://Compliance_EVASION/Evasion/Training/

After that in Training Folder - There is Some Sub Folder like - APRIL_2019, MAY_2019 --> DECEMBER_2019.

Each folder is some excel file - TABLE1.XLS, TABLE2.XLS, TABLE3.XLS, TABLE4.XLS

XLS File is in every month in same format.

How I can fetch the data from these folder to Qlik.

Thanks.

Labels (2)
1 Reply
justISO
Specialist
Specialist

Hi, try to search how to loop load from folders as there are multiple posts about similar need already in forum. You can start from there:

https://community.qlik.com/t5/QlikView-App-Dev/Loop-through-files-in-folder-and-load-into-same-table...

https://community.qlik.com/t5/New-to-Qlik-Sense/loop-through-folders-and-sub-folders-to-load-multipl...