Power BI: How to add custom column when "append queries as new table"

Question

I followed the instructions on the Microsoft web site to merge multiple tables into a single table or as they are called 'append queries to new table'. It works.

The problem is if I add a new custom column to each table after importing the tables into Power BI, ex I add a column called 'Group' to each table and for Table1 I populate the column with 'GroupA' and Table2 with 'GroupB' etc, when I click 'append queries to new table' it only merges the original columns and ignores the custom column I added.

Is there a solution to merge the custom columns too? These custom columns are identifiers so I need them. Thanks in advance for your suggestions.

Answer 1

teylyn answered the question in a comment posted on the question:

the append command will append the tables as they exist at that point. Just work the append command after you added all the custom columns to the two tables.