JoinKind.Inner (0) is an enumeration that specifies the kind of join operation. It is a member of the JoinKind.Type and represents an inner join which contains a row for each pair of rows from the specified tables that were determined to match based on the specified key columns.
Imagine this – you’re joining the ‘Left Table’ and the ‘Right Table’ on a common column. The image below shows how an ‘inner join’ gives you a new table that consists only of the shared or common elements.
Examples
The inner join returns rows in Table1 matching with rows in Table2. To specify the inner join operation for the Table.NestedJoin function you can use its 6th argument.
= Table.NestedJoin(
CustomersTable,
{"CustomerID_1"},
OrdersTable,
{"CustomerID_2"},
"Orders"
JoinKind.Inner // specifies the JoinKind
)
/* ----------------------------------------
You can also write the short-hand value
------------------------------------------ */
= Table.NestedJoin(
CustomersTable,
{"CustomerID_1"},
OrdersTable,
{"CustomerID_2"},
"Orders"
0 // the concise way to specify the inner join
)Related articles
Learn more about JoinKind.Inner in the following articles:
- Join Types in Power Query
Power Query has different join types for merging queries. Mastering them allows you to easily retrieve new values, keep relevant ones or discard them.. » Read more
Related enumerations
Other related enumerations are:
Applies to
Here’s a list of functions that work with JoinKind.Type:
2023-2024 © BI Gorilla. All rights are reserved. Information from Microsoft docs is property of Microsoft Corp. | Privacy Policy