Forum Discussion
Solved
Append Queries - Add Source Table Column
I would like to have a column in an appended table which details the original table. For example, I have timesheets for individual team members which are appended to one table with all recorded time....
Create a Folder and put the excel files into the folder, then connect to the folder-> Load. In query editor, you will get below:
Then click the expand icon in the Content column, you can achieve the final result.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
v-yuta-msft
Community Support
Community Support
Create a Folder and put the excel files into the folder, then connect to the folder-> Load. In query editor, you will get below:
Then click the expand icon in the Content column, you can achieve the final result.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.