topic Crash on Next SubDirectory in QlikView

Crash on Next SubDirectory

djbloiss — Mon, 01 Oct 2018 17:49:47 GMT

I need to be able to loop through the directory '\\FILESVR1\FinalDailyDispatchSheet$\' and all subdirectories under it, to load all .xls files. It works for the main directory but will not find the subdirectories. It is crashing on the next subdirectory statement. What am I doing wrong?

Here is my code (with the unnecessary pieces taken out):

DIRECTORY \\FILESVR1\FinalDailyDispatchSheet$\;

for Each subDirectory in DirList(Dir & '*')

for Each file in FileList('*.xls')

DeliveryData:

LOAD

@1 as Run,

@2 as [Description],

@3 as [Stops],

@4 as [Pieces]

FROM [$(file)]

(biff, no labels, table is Table1)

;

next file

NEXT SubDirectory

;

Re: Crash on Next SubDirectory

marcus_sommer — Tue, 02 Oct 2018 10:56:58 GMT

Take a look here: https://help.qlik.com/en-US/sense/June2018/Subsystems/Hub/Content/Scripting/ScriptControlStatements/For%20Each.htm

- Marcus

Re: Crash on Next SubDirectory

andrey_krylov — Tue, 02 Oct 2018 11:37:02 GMT

Hi Daniel. I've marked the errors. But it loops only subdirs and no root

DIRECTORY \\FILESVR1\FinalDailyDispatchSheet$\;

for Each subDirectory in DirList(Dir & '*')

for Each file in FileList(subDirectory & '\*.xls')

DeliveryData:

LOAD

@1 as Run,

@2 as [Description],

@3 as [Stops],

@4 as [Pieces]

FROM [$(file)]

(biff, no labels, table is Table1)

;

next file

NEXT subDirectory

;

Re: Crash on Next SubDirectory

andrey_krylov — Tue, 02 Oct 2018 11:52:02 GMT

Or try this SUB

SUB LoadFiles(Root)

for each FoundFile in filelist( Root & '\*.xls')

LOAD msgbox('$(FoundFile)') AutoGenerate 1;

next FoundFile

for each SubDirectory in dirlist( Root & '\*' )

call LoadFiles(SubDirectory)

next SubDirectory

ENDSUB