JoinAlgorithm.LeftIndex

Updated on

JoinAlgorithm.LeftIndex (5) is an enumeration that specifies the join algorithm to be used in the join operation. It is a member of the JoinAlgorithm.Type and indicates that the algorithm, in batches, uses the keys from the left table to do predicate-based queries against the right table. This algorithm is recommended when the right table is large, supports folding of Table.SelectRows, and contains few rows that are expected to match a left row.

Examples

The LeftIndex join algorithm is recommended when Table2 is large, supports query folding and contains few rows of Table1:

= Table.Join(
     Table1,  
     {"A1"}, 
     Table2, 
     {"A2"},
     JoinKind.Inner, 
     JoinAlgorithm.LeftIndex // performs a join with the LeftIndex algorithm
)

Other related enumerations are:

Applies to

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

Contribute » | Contributors: Rick de Groot