Looping through files using DocumentPath()

[martyn_birzys]

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

[maxgro · Accepted solution]

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

trace $(vPath);

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

  trace $(File);

  fileTable:

  LOAD '$(File)' as Name,

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

  FileTime( '$(File)' ) as FileTime

  autogenerate 1;

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

NEXT File

[martyn_birzys]

Tried this syntax too, I was only missing the single quotes. It looks wrong at the beginning - the script editor does not recognize the variable inside quotation marks. But it works, thanks for that.