JoinKind.LeftSemi

Updated on

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

Examples

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

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

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

Other related enumerations are:

Contribute » | Contributors: Rick de Groot