JoinAlgorithm.RightIndex

Updated on

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

Examples

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

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

Other related enumerations are:

Applies to

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

BI Gorilla Youtube Channel

Contribute » | Contributors: Rick de Groot