JoinKind.Type - Enumeration

JoinKind.Type specifies the kind of join operation.

Enumeration Options

Enumerations simplify the process of selecting options within a function. To specify the JoinKind.Type, users have the option to either input the below Argument description (which provides more information) or the shorter Value (which provides a more concise representation).

Argument	Value	Description
JoinKind.Inner	0	A possible value for the optional `JoinKind` parameter in `Table.Join`. The table resulting from an inner join contains a row for each pair of rows from the specified tables that were determined to match based on the specified key columns.
JoinKind.LeftOuter	1	A possible value for the optional `JoinKind` parameter in `Table.Join`. A left outer join ensures that all rows of the first table appear in the result.
JoinKind.RightOuter	2	A possible value for the optional `JoinKind` parameter in `Table.Join`. A right outer join ensures that all rows of the second table appear in the result.
JoinKind.FullOuter	3	A possible value for the optional `JoinKind` parameter in `Table.Join`. A full outer join ensures that all rows of both tables appear in the result. Rows that did not have a match in the other table are joined with a default row containing null values for all of its columns.
JoinKind.LeftAnti	4	A possible value for the optional `JoinKind` parameter in `Table.Join`. A left anti join returns that all rows from the first table which do not have a match in the second table.
JoinKind.RightAnti	5	A possible value for the optional `JoinKind` parameter in `Table.Join`. A right anti join returns that all rows from the second table which do not have a match in the first table.
JoinKind.LeftSemi	6	A possible value for the optional `JoinKind` parameter in `Table.Join`. A left semi join returns all rows from the first table that have a match in the second table.
JoinKind.RightSemi	7	A possible value for the optional `JoinKind` parameter in `Table.Join`. A right semi join returns all rows from the second table that have a match in the first table.

Applies to

Here’s a list of functions that work with JoinKind.Type:

Contribute » | Contributors: Rick de Groot
Microsoft documentation: https://learn.microsoft.com/en-us/powerquery-m/joinkind-type