Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello All,
right now my company is saving our daily reports in a folder and it's updated daily with new reports added in as new files.
so if i am trying to grab every files in this folder automatically,how do i do it?
Your files must have the same structure, in this case you can use a loop:
let
path = '..\..\MyDir\*.*';
for Each File in FileList (path)
margin_tmp:
LOAD
....
fields
....
FROM
$(File) (ooxml, embedded labels, table is [MySheet]);
NEXT
Your files must have the same structure, in this case you can use a loop:
let
path = '..\..\MyDir\*.*';
for Each File in FileList (path)
margin_tmp:
LOAD
....
fields
....
FROM
$(File) (ooxml, embedded labels, table is [MySheet]);
NEXT
sweet!!!! THANK YOU SO MUCH Alexandros!!!