Table.Combine

语法

Table.Combine(tables as list, optional columns as any) as table

关于

返回一个表，此表是合并表 tables 的列表的结果。 生成的表的行类型结构将由 columns 定义，或由输入类型的联合定义（如果未指定 columns）。

示例 1

将以下三个表合并在一起。

使用情况

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"] })

示例 2

合并结构不同的三个表。

使用情况

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"] })

示例 3

合并两个表并投影到给定类型。

使用情况

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] })