Automatically load every file in a folder and perform the same operation to each of them

[Anonymous]

Hi everybody,

I'm trying to load everyfile in a folder an execute the same actions to everyone once they are in the same query.

Let me explain myself:

1) I have this files in one folder:

          File_20200601.xlsx

          File_20200602.xlsx

          File_20200603.xlsx

          ....

         One for each day and I extract a new one every day.

2) For each file, I need to add a column with the date in the file name File_yyyymmdd.xlsx

3) Then, add all of them to the same query.

Is it possible to do that?

Thanks a lot!

Jorge

[collinq · Accepted solution]

HI @Anonymous ,

If you use the FOLDER as the data source then the system automatically combines all of the files.  AND, the system will automatically add a "Source Name" column that will indicate which file that set of rows comes from.  Then, when you add the new files the next day, they will automatically all keep appending.  

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!