Forum Discussion
Automatically load every file in a folder and perform the same operation to each of them
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
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!
1 Reply
- collinq
Super User
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!