An operation in Power Query that combines multiple tables by stacking their rows on top of each other.
Prova med AIThe Append Query feature creates a single new table by adding the rows of one or more source tables to the end of a primary table. It requires that the tables share a similar structure, typically with the same column names, to ensure data aligns correctly in the resulting dataset.
If you have separate sales tables for 'January' and 'February' with identical columns, you can append them to create a single 'Year-to-Date' master table.
Append stacks rows to increase the number of records, while Merge joins tables side-by-side based on common columns to add more attributes.