Append Query

[Anonymous]

Hi All! I am and trying to figure out how to edit/modify an existing append I created in PowerQuery/Transform Data. In the near future, I may need to add existing Excel workbooks to my append, and I don't want to run the risk of having to completely rebuild an my append from scratch..

Please advise!

[Anonymous]

I found it now. Thank you very much! 

[BA_Pete]

Hi @Anonymous ,

In you current query that you append your tables in, you will have an append step with Table.Combine in the code. You can just add new query names to this for the new Excel queries that you have brought into Power Query:

Append Queries = Table.Combine({"query A", "query B"})

=>

Append Queries = Table.Combine({"query A", "query B", "query C", "query D"})

Pete

[Anonymous]

Here is a snapshot of one of my Append Queries.. I am not seeing the 'Table.Combine' statement that you provided. Am I missing a step? 

I created my append query by going to Transform data > Append Queries > Append Queries as New

[BA_Pete · Accepted solution]

Hi @Anonymous ,

The screenshot you provided just shows one step changing data types, nothing to do with appending.

If you select your appended query (the one that was created by 'Append Queries as New'), you should see that the Source step is the Table.Combine function.

Pete