Merge excel files to one meanwhile a new column indicate year and month

Each month, I have an Excel file with a filename such as “AR_aging_202401”, and the format of these files remains consistent each month. Now, I need to merge them into a single file and add a new column named “month-year”, where the content of this column will indicate the corresponding year and month of each original file.

@war1sgh you can just use the Excel reader node and import several files at once if they have the same format and also add the file names / path as a column

Another option is to loop thru a list of Excel sheets and files

2 Likes

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.