Table.NestedJoin
Performs a join between tables on supplied columns and produces the join result in a new column.
function (table1as table, optionalkey1as nullable any, optionaltable2as nullable any, optionalkey2as nullable any,newColumnNameas text, optionaljoinKindas nullable any, optionalkeyEqualityComparersas 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 key1 (for table1) and key2 (for table2). The results are entered into the column named newColumnName.The optional
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.Table.Transformation
Last modified 4yr ago