Table.NestedJoin

針對提供的資料行執行資料表之間的聯結，並且在新的資料行中產生聯結結果。

Syntax

Table.NestedJoin(
    table1 as table,
    key1 as any,
    table2 as any,
    key2 as any,
    newColumnName as text,
    optional joinKind as JoinKind.Type,
    optional keyEqualityComparers as list
) as table

Remarks

根據 key1 (代表 table1) 和 key2 (代表 table2) 所選取之索引鍵資料行的值是否相等，聯結 table1 的資料列與 table2 的資料列。結果會輸入名為 newColumnName 的資料行。

joinKind (選擇性) 可指定要執行的聯結種類。若未指定 joinKind，預設會執行左方外部聯結。

可以選擇納入一組 keyEqualityComparers 以指定如何比較索引鍵資料行。此功能目前僅供內部使用。

Examples

Example #1

使用單一索引鍵資料行聯結兩個數據表。

Table.NestedJoin(
    Table.FromRecords({
        [CustomerToCall = 1],
        [CustomerToCall = 3]
    }),
    {"CustomerToCall"},
    Table.FromRecords({
        [CustomerID = 1, Name = "Bob", Phone = "123-4567"],
        [CustomerID = 2, Name = "Jim", Phone = "987-6543"],
        [CustomerID = 3, Name = "Paul", Phone = "543-7890"],
        [CustomerID = 4, Name = "Ringo", Phone = "232-1550"]
    }),
    {"CustomerID"},
    "CustomerDetails"
)

Result:

Table.FromRecords({
    [CustomerToCall = 1, CustomerDetails = Table.FromRecords({[CustomerID = 1, Name = "Bob", Phone = "123-4567"]})],
    [CustomerToCall = 3, CustomerDetails = Table.FromRecords({[CustomerID = 3, Name = "Paul", Phone = "543-7890"]})]
})

Category

Table.Transformation