Forum Discussion
Solved
Append Table include source name
Hello, I need to merge together our team projects to create a dashboard, with the option to filter by the original table name. I've managed to merge my two data tables to create my append table b...
Prior to the append step, add a custom column in both tables to be appended with the same column name. For example, add a column called "SourceTable" with a formula in the add column pop up of ="Table1" or ="Table2".
Pat
That data isn't available to Power Query. If it is a one time thing, then mahoneypat solution will work.
If you want to have a little more control over it, consider this. I a table of my table names using the #table function.
Then I used Expression.Evaluate from an added column that got the data from those table names:
At that point, I just needed to expand the table contents. All data is the same format (column names, etc.) so it automatically does the Append operation.
You can see the full example in this file.