Append Table include source name

[Shelley-Baynton]

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 😄

[edhans]

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.

[mahoneypat · Accepted solution]

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

[Shelley-Baynton]

@mahoneypat thank you!

That worked perfectly 🙂