FileList Not working

Anonymous — Wed, 30 May 2018 16:44:48 GMT

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;

Re: FileList Not working

rubenmarin — Wed, 30 May 2018 16:55:28 GMT

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/ScriptControlStatements/For%20Each…

topic FileList Not working in QlikView

FileList Not working

Re: FileList Not working