JoinAlgorithm.Dynamic

JoinAlgorithm.Dynamic (0) 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 join algorithm is automatically chosen based on inspecting the initial rows and metadata of both tables.

Examples

The Dynamic join algorithm is useful when you want to let Power Query decide which algorithm to use. It automatically chooses the best algorithm based on a scan of the rows and metadata of the tables involved in the join. How it works under the hood is (currently) undocumented.

= Table.Join(
     Table1,  
     {"A1"}, 
     Table2, 
     {"A2"},
     JoinKind.Inner, 
     JoinAlgorithm.Dynamic // join algorithm chosen automatically
)

Related enumerations

Other related enumerations are:

• JoinAlgorithm.LeftHash
• JoinAlgorithm.LeftIndex
• JoinAlgorithm.PairwiseHash
• JoinAlgorithm.RightHash
• JoinAlgorithm.RightIndex
• JoinAlgorithm.SortMerge

Applies to

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

• Table.Join

Contribute » | Contributors: Rick de Groot