JoinKind.RightSemi

Updated on

JoinKind.RightSemi (7) is an enumeration that specifies the kind of join operation. It is a member of the JoinKind.Type and represents a right semi join which returns all rows from the second table which do not have a match in the first table.

Examples

= Table.NestedJoin(
      CustomersTable,
      {"CustomerID_1"},
      OrdersTable,
      {"CustomerID_2"},
      "Orders"           
      JoinKind.RightSemi // specifies the JoinKind
  )

/* ----------------------------------------
    You can also write the short-hand value
 ------------------------------------------ */

= Table.NestedJoin(
      CustomersTable,
      {"CustomerID_1"},
      OrdersTable,
      {"CustomerID_2"},
      "Orders"           
      7                   // the concise way to specify the right semi join
  )

Other related enumerations are:

Contribute » | Contributors: Rick de Groot