Table.NestedJoin
Merge the rows of table1 with the rows of table2 using the values of key1 (for table1) and key2 (for table2) to determine equality. The combined results will be placed in a new column called newColumn...
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 tableMerge the rows of table1 with the rows of table2 using the values of key1 (for table1) and key2 (for table2) to determine equality. The combined results will be placed in a new column called newColumnName.
You can specify the type of join to perform using the optional joinKind parameter. If not specified, a left outer join will be performed by default.
Additionally, keyEqualityComparers can be included to define how the key columns should be compared. Please note that this keyEqualityComparers feature is currently intended for internal use only.
Merge two tables by connecting them through a shared key column. Use Power Query MTable.NestedJoin() function with the following parameters:
- First table: {"CustomerToCall"}
- Second table: {"CustomerID"}
After the merge, the output table will display the corresponding details for each matching key value. For example, when CustomerToCall is 1, the CustomerDetails will show the record for CustomerID 1 with Name as "Bob" and Phone number as "123-4567". Similarly, when CustomerToCall is 3, the CustomerDetails will display the details for CustomerID 3 with Name as "Paul" and Phone number as "543-7890".