DataFlow.JoinAsync Method

Definition

Namespace:: Microsoft.DataPrep.Common

Assembly:: Microsoft.DataPrep.dll

Important

Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.

Overloads

JoinAsync(DataFlow, List<KeyValuePair<String,String>>, JoinType, String, String, List<String>, List<String>)	Creates a new Dataflow that is a result of joining this Dataflow with the provided right_dataflow.
JoinAsync(DataFlow, DataFlow, List<KeyValuePair<String,String>>, JoinType, String, String, List<String>, List<String>)	Creates a new Dataflow that is a result of joining two provided Dataflows.

JoinAsync(DataFlow, List<KeyValuePair<String,String>>, JoinType, String, String, List<String>, List<String>)

Creates a new Dataflow that is a result of joining this Dataflow with the provided right_dataflow.

public System.Threading.Tasks.Task<Microsoft.DataPrep.Common.DataFlow> JoinAsync(Microsoft.DataPrep.Common.DataFlow rightDataFlow, System.Collections.Generic.List<System.Collections.Generic.KeyValuePair<string,string>> joinKeyPairs, Microsoft.DataPrep.Common.JoinType joinType = Microsoft.DataPrep.Common.JoinType.Inner, string leftColumnPrefix = "l_", string rightColumnPrefix = "r_", System.Collections.Generic.List<string> leftNonePrefixedColumns = null, System.Collections.Generic.List<string> rightNonePrefixedColumns = null);

member this.JoinAsync : Microsoft.DataPrep.Common.DataFlow * System.Collections.Generic.List<System.Collections.Generic.KeyValuePair<string, string>> * Microsoft.DataPrep.Common.JoinType * string * string * System.Collections.Generic.List<string> * System.Collections.Generic.List<string> -> System.Threading.Tasks.Task<Microsoft.DataPrep.Common.DataFlow>

Parameters

rightDataFlow: DataFlow

Right Dataflow to join with.

joinKeyPairs: List<KeyValuePair<String,String>>

Key column pairs. List of columns names where each value forms a key pair to join on. For instance: [(column_from_left_dataflow, column_from_right_dataflow)]

joinType: JoinType

Type of join to perform. Match is default.

leftColumnPrefix: String

Prefix to use in result Dataflow for columns originating from left_dataflow. Needed to avoid column name conflicts at runtime.

rightColumnPrefix: String

Prefix to use in result Dataflow for columns originating from right_dataflow. Needed to avoid column name conflicts at runtime.

leftNonePrefixedColumns: List<String>

List of column names from left_dataflow that should not be prefixed with left_column_prefix. Every other column appearing in the data at runtime will be prefixed.

rightNonePrefixedColumns: List<String>

List of column names from right_dataflow that should not be prefixed with right_column_prefix. Every other column appearing in the data at runtime will be prefixed.

Returns

Task<DataFlow>

The new Dataflow.

Applies to

JoinAsync(DataFlow, DataFlow, List<KeyValuePair<String,String>>, JoinType, String, String, List<String>, List<String>)

Creates a new Dataflow that is a result of joining two provided Dataflows.

public static System.Threading.Tasks.Task<Microsoft.DataPrep.Common.DataFlow> JoinAsync(Microsoft.DataPrep.Common.DataFlow leftDataFlow, Microsoft.DataPrep.Common.DataFlow rightDataFlow, System.Collections.Generic.List<System.Collections.Generic.KeyValuePair<string,string>> joinKeyPairs, Microsoft.DataPrep.Common.JoinType joinType = Microsoft.DataPrep.Common.JoinType.Inner, string leftColumnPrefix = "l_", string rightColumnPrefix = "r_", System.Collections.Generic.List<string> leftNonPrefixedColumns = null, System.Collections.Generic.List<string> rightNonPrefixedColumns = null);

static member JoinAsync : Microsoft.DataPrep.Common.DataFlow * Microsoft.DataPrep.Common.DataFlow * System.Collections.Generic.List<System.Collections.Generic.KeyValuePair<string, string>> * Microsoft.DataPrep.Common.JoinType * string * string * System.Collections.Generic.List<string> * System.Collections.Generic.List<string> -> System.Threading.Tasks.Task<Microsoft.DataPrep.Common.DataFlow>