Forum Discussion

nerd2000's avatar
nerd2000
Advocate I
8 years ago
Solved

displaying source table name in append field

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:   Appe...
Need Help
Tips and Tricks
Tutorial Requests
  • v-chuncz-msft's avatar
    v-chuncz-msft
    8 years ago

    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")})
lucaspon's avatar
lucaspon
New Member
6 years ago

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?