Help: How to automatically grab new files from a folder

[#1]

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?

[alexandros17 · Accepted solution]

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

[#3]

sweet!!!! THANK YOU SO MUCH  Alexandros!!!