In Power Query, when combining/appending multiple tables is there a way to add a column which will give the name of file/table the data is from.

[prodigal_nerd]

I am trying to combine tables from 10 SharePoint excel files. Each file is named as per the owner who works on the file. I want to add a column after combining/appending all 10 tables into one, which will give me the file's/tables name (ie owners name) for example the first 100 rows of data are from John's file and next 100 rows from Mary's file and so on... So the column should have "John" for the first hundred rows and "Jane" for the next 100 rows

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: In Power Query, when combining/appending multiple tables is there a way to add a column which will give the name of file/table the data is from.
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Alex Blakenburg]

I no longer have access to a sharepoint folder but perhaps this will work for you.
Its a 14 min video but you will get to the point of having a report with the File name as a column by the 4 min mark.
It does assume that you are picking up all the files from the same folder though.