How to load multiple files with their last modified date

Answering the question below:

I have history data which I need to load into sql, there are 31 files per month, and it is 18 months’ worth of data. All the files have the same field names but I would need to add modified date as a field name so that I can see when that file was created.

Step 1: Load multiple files from the source folder, include file paths as a new column.

Step 2: Generate a list of files in the same folder. Check “Date modified” to include it into the result.


Step 3: Merge “Date modified” into the main table.

Full example:
multi-load last (189.1 KB)

1 Like