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
)Related enumerations
Other related enumerations are:
- JoinAlgorithm.Dynamic
- JoinAlgorithm.LeftHash
- JoinAlgorithm.PairwiseHash
- JoinAlgorithm.RightHash
- JoinAlgorithm.RightIndex
- JoinAlgorithm.SortMerge
Applies to
Here’s a list of functions that work with JoinAlgorithm.Type:
