Forum Discussion
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 but I'm stuck on how to pull through original source name.
I've tried using the ContentTypeID unfortunatelty it only shows ID Number and not the original table name
Thank you in advance 😄
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
3 Replies
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.
