Forum Discussion
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:
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
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")})
7 Replies
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")})Wonderful solution, thank you! Came in very handy in my work today.
Not pretty, but it worked, thank you.
This really should be a built-in function, it would make the append query much more useful.Thanks a lot for this. It came in very handy. I needed to combine 72 Tables for cleaning. It worked well.
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?
There is a workaround using #sections now!
Thank you, the problem was soluted
