Skip to main content
Announcements
Qlik Connect 2024! Seize endless possibilities! LEARN MORE
cancel
Showing results for 
Search instead for 
Did you mean: 
Anonymous
Not applicable

FileList Not working

I have a folder named LogsToday which contains 10 sub folders of differenct application and inside each folder logs of subsequent application . I am tring below code but unable to capture all 10 folder names in a table

let LogFilesStoredPath = 'C:\Users\prince.panghal\Desktop\Logs Analyser\LogsToday';

let a ='Derivatives.EmirRegulatoryReport.Extract.qvw';

for each file in     FileList('C:\Users\prince.panghal\Desktop\Logs Analyser\LogsToday\*')

trace abc;

abf:

load

'$(file)' as new123

autogenerate 1;

next;

1 Reply
rubenmarin

For directories there is the DirList() function.

Example 2 of the for each help tells how to read files from all subfolders:

https://help.qlik.com/en-US/qlikview/November2017/Subsystems/Client/Content/Scripting/ScriptControlS...