Table.Combine

Table.Combine
Returns a table that is the result of merging a list of tables.
function (tables as list, optional columns as nullable any) as table
Description
Returns a table that is the result of merging a list of tables, tables. The resulting table will have a row type structure defined by columns or by a union of the input types if columns is not specified.
Category
Table.Row operations
Examples
Merge the three tables together.
Table.Combine({Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]}), Table.FromRecords({[CustomerID = 2, Name = "Jim", Phone = "987-6543"] }),Table.FromRecords({[CustomerID = 3, Name = "Paul", Phone = "543-7890"]})})
Table.FromRecords({[CustomerID=1,Name="Bob",Phone="123-4567"],[CustomerID=2,Name="Jim",Phone="987-6543"],[CustomerID=3,Name="Paul",Phone="543-7890"]})
Merge three tables with different structures.
Table.Combine({Table.FromRecords({[Name="Bob",Phone="123-4567"]}), Table.FromRecords({[Fax="987-6543", Phone="838-7171"] }),Table.FromRecords({[Cell = "543-7890"]})})
Table.FromRecords({[Name="Bob",Phone="123-4567",Fax=null,Cell=null],[Name=null,Phone="838-7171",Fax="987-6543",Cell=null],[Name=null,Phone=null,Fax=null,Cell="543-7890"]})
Merge two tables and project onto the given type.
Table.Combine({Table.FromRecords({[Name="Bob",Phone="123-4567"]}), Table.FromRecords({[Fax="987-6543", Phone="838-7171"] }),Table.FromRecords({[Cell = "543-7890"]})}, {"CustomerID", "Name"})
Table.FromRecords({[CustomerID=null,Name="Bob"],[CustomerID=null,Name=null],[CustomerID=null,Name=null]})

Table.ColumnsOfType

Table.CombineColumns

Last modified 3yr ago

Copy link

On this page

Table.Combine

Description