topic Re: Looping through files using DocumentPath() in QlikView

Looping through files using DocumentPath()

martyn_birzys — Tue, 04 Nov 2014 16:24:29 GMT

I am trying to loop through 3 .qvd files in QVDs subfolder, but all I'm getting is blank screen (empty table).

LET vPath = Replace (DocumentPath (), '\' & DocumentName (), '')&'\QVDs';

FOR Each File in filelist ($(vPath))

fileTable:

LOAD

'$(File)' as Name,

FileSize( '$(File)' ) as Size,

FileTime( '$(File)' ) as FileTime

autogenerate 1;

TRACE folderpath-- $(vPath) . filename-- $(File);

NEXT File

Re: Looping through files using DocumentPath()

maxgro — Tue, 04 Nov 2014 20:36:55 GMT

LET vPath = Replace (DocumentPath (), '\' & DocumentName (), '')&'\QVDs';

trace $(vPath);

FOR Each File in filelist ('$(vPath)\*.*')

trace $(File);