Table.Combine Function in Power Query

The Table.Combine function returns a table that is the result of merging a list of tables.

Syntax

The function has the following parameters:

• tables: A list of tables that we want to combine.
• columns: The columns to return in the resultant table.

The resulting table will have a row type structure defined by columns parameter or by a union of the input types if columns parameter is not specified.

Description:

• It takes a list of tables and merges them into a single table by appending rows.
• The columns are combined based on column names.
• If the tables have different columns, missing values will be filled with null.

Example: Suppose we have three tables that we want to combine.
Table1 table is shown below:

Table2 table is shown below:

Table3 table is shown below:

To combine all the three table we can use the Table.Combine function as shown below:

Power Query M

let
  Source = Table.Combine({Table1, Table2, Table3})
in
  Source 

The output of the above code is shown below:

We can see the all the rows from the given tables are merged and in the same sequence as the input given tables.

Combine Specific Columns We can combine only specific columns by giving the optional columns parameter in the function.

Example: Combine only Name and Branch from the given input tables.

Power Query M

let
  Source = Table.Combine({Table1, Table2, Table3}, {"Name", "Branch"})
in
  Source 

The output of the above code is shown below: