Table.Combine Function in Power Query
The Table.Combine function returns a table that is the result of merging a list of tables. The tables must all have the same row type structure.
Syntax
Table.Combine(tables as list, optional columns as any) as table
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:
