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.
multi-load last modified.zip (189.1 KB)