Join Data Table
Combine two data tables.
Last updated
Combine two data tables.
Last updated
The activity combines the rows from two data table with the help of join rules and joins type applied on both data tables. The resulting data table is stored in a variable.
DataTable 1 :
The first data table used in the join operation.
DataTable 2 : The second data table used in the join operation.
Join Type : The type of join operation used in join data table activity.
Inner
- Takes all the rows from DataTable1 and DataTable2, that satisfy the join rule. The rows that do not satisfy the rule are removed from the resulting table.
Left
- Take all rows from DataTable1 and only the rows from DataTable2 which satisfy the join rule. Null values are inserted for the rows from DataTable1 that do not have a match in DataTable2.
Full
- Take all rows from DataTable1 and DataTable2 which does not consider the join rule. Null values are inserted for the rows from both data tables that do not have a match.
Join Rules: The operations that applied to join data tables.
The variable that stores the resulting data table of the join operation.
Output :