JoinKind.Type

Updated on

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).

ArgumentValueDescription
JoinKind.Inner0A 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.LeftOuter1A 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.RightOuter2A 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.FullOuter3A 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.LeftAnti4A 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.RightAnti5A 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.

Applies to

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

BI Gorilla Youtube Channel

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