27. 12. 2018
FOR w = 1 TO 52
LET w = w;
LET vFile = '\\server\adresar\T' & $(w) & '.xlsx';
if NOT IsNull(FileTime('$(vFile)')) then
Data:
LOAD
A as Article,
...
'$(w)' as [Week]
From [$(vFile)]
(ooxml, no labels, header is 0 lines, table is List1);
end if;
Next;