displaying source table name in append field

[nerd2000]

I am appending several queries eg: 

query A

query B

query C

I want to create a custom column in the append result query that will display the source query name the record was from eg:

Append results:

fruit         qty        source query

apple        23        query A

pear           4         query A

orange       33       query B

grapefruit    4        query B

....and so on

[bluefalcon]

Thank you, the problem was soluted

[ManoukUBN]

There is a workaround using #sections now!

Get List of Queries in Power BI - RADACAD

[lucaspon]

This is nice but, what if I have like 100 tables I need to append? How can we make this code dynamic so that it gets the table name for each row?

[v-chuncz-msft · Accepted solution]

@nerd2000,

You may change code in The Advanced Editor.

    Source = Table.Combine({Table.AddColumn(#"query A", "source query", each "query A")
                            , Table.AddColumn(#"query B", "source query", each "query B")
                            , Table.AddColumn(#"query C", "source query", each "query C")})

[CatPhish]

Not pretty, but it worked, thank you.

This really should be a built-in function, it would make the append query much more useful.

[Olugbenga]

Thanks a lot for this. It came in very handy. I needed to combine 72 Tables for cleaning. It worked well.

[sergey-fedotov]

Wonderful solution, thank you! Came in very handy in my work today.