Table.NestedJoin(table1 as table, key1 as any, table2 as any, key2 as any, newColumnName as text, optional joinKind as nullable number, optional keyEqualityComparers as nullable list) as table
Joins the rows of
table1 with the rows of
table2 based on the equality of the values of the key columns selected by
table2). The results are entered into the column named
joinKind specifies the kind of join to perform. By default, a left outer join is performed if a
joinKind is not specified.
An optional set of
keyEqualityComparers may be included to specify how to compare the key columns.