Add "Name" Column in Power Query - Append

[mwl_y]

When making a query with multiple tables, a column called "Name" is automatically created, containing the table name...
When appending queries, however, it doesn't do this. Is there a way to add a "Name" column to my appended query, so I can see which query the data came from?

My queries (TemplatePerson and TemplatePerson2) are "connection only", as I do not want them to physically reside in my workbook, but "Append1" will be loaded to a new sheet.

 

[johnny51981]

Can you show where you are seeing the "Name" column?

 

[JEC]

add a new column in each table with the name of that table. Make sure the two tabels have te same headernames(exactly). Then you can append

 

[Alex Blakenburg]

Try creating a blank query and insert the code below.
Change the Filter to be whatever you need it to be to pick up the tables you want.
Then Expand the Tables column to pick up the fields you want in the output.

let
    Source = Excel.CurrentWorkbook(),
    #"Filtered Rows" = Table.SelectRows(Source, each Text.StartsWith([Name], "TemplatePerson"))
in
    #"Filtered Rows"

 

[AlienSx]

    Record.ToTable(
        Record.SelectFields(
            #shared, 
            {"TemplatePerson", "TemplatePerson2"}
        )
    )

 

[mwl_y]

    Record.ToTable(
        Record.SelectFields(
            #shared,
            {"TemplatePerson", "TemplatePerson2"}
        )
    )

Thanks, I think this is what I need; I'm still quite new to using Power Query - where would I insert this code? This is what is currently in the editor:

let
    Source = Table.Combine({TemplatePerson, TemplatePerson2})
in
    Source

 

[mwl_y]

Try creating a blank query and insert the code below.
Change the Filter to be whatever you need it to be to pick up the tables you want.
Then Expand the Tables column to pick up the fields you want in the output.

let
    Source = Excel.CurrentWorkbook(),
    #"Filtered Rows" = Table.SelectRows(Source, each Text.StartsWith([Name], "TemplatePerson"))
in
    #"Filtered Rows"

Thanks, but unfortunately this won't work... as mentioned, I'm appending queries, not using tables from the same workbook
On a side note, "TemplatePerson" is a placeholder name - these queries will have different names (think Amy, Bob, Dave, etc)

 

[AlienSx]

where would I insert this code?

simply replace your Table.Combine({TemplatePerson, TemplatePerson2}) with my code.