In short, how do I create a column that lists a row's corresponding filename when combining multiple workbooks from a SharePoint folder?
I am sourcing multiple workbooks (raw reports) from a SharePoint folder. Annoyingly the reports do not have dates included in the data. However, I need a date to be included.
To get around the issue of no date, all the reports have been named with their corresponding date.
In the past using a local folder or a synced one drive folder I have been able to use the transform file name into text and then date when I and transforming and combining the data. However, when I have done this in the past I ultimately run into data source issues. This project needs to be portable and not run into these issues. Thus, I have been trying the SharePoint folder option.
Steps Taken So Far
1. Loaded my SharePoint folder URL
2. Filtered the Folder Path to correct folder
3. (STUCK) Combined Files - no Name column once combined