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")})
v-chuncz-msft's avatar
v-chuncz-msft
Community Support
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")})
CatPhish's avatar
CatPhish
Advocate I
5 years ago

Not pretty, but it worked, thank you.

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