Notifications
Clear all
Power Query
3
Posts
2
Users
0
Reactions
69
Views
Topic starter
I am creating a query from an Excel spreadsheet that has multiple tables separated over multiple tabs. Is there any way to create a column in the query that displays the source table or worksheet name?
Thanks,
Brian
Posted : 01/12/2018 1:31 pm
Hi Brian,
If you use the Excel.Workbook(File.Contents( approach as shown in lesson 3.02, then when you expand the content column it will retain the sheet names.
Likewise, if you want to get data in the current workbook as shown in lesson 3.01, then it will also keep the table name once you expand the data.
Mynda
Posted : 01/12/2018 11:52 pm
Topic starter
Thanks Mynda! That's exactly what I needed.
Posted : 05/12/2018 5:22 pm
