Join Data Tables
Combines rows from two DataTables based on matching column values.
Behaviour
Risk: None · Idempotent: Yes · Safe to retry: Yes · Recovery: Not replayed after a crash
Package System activities VeloPhex.System.Activities 0.7.1-rc.12 · Supported (Core profile) · type id velophex.system.joinDataTables
Properties#
Input#
Data Table 1#
DataTable1 · DataTable · Required · Default: Not specified in package metadata
The first (left) DataTable.
Data Table 2#
DataTable2 · DataTable · Required · Default: Not specified in package metadata
The second (right) DataTable.
Column 1#
Column1 · String · Required · Default: Not specified in package metadata
The column name in DataTable 1 to match on.
Column 2#
Column2 · String · Required · Default: Not specified in package metadata
The column name in DataTable 2 to match on.
Join Type#
JoinType · String · Optional · Default: Inner
The join operation: Inner, Left, or Full.
Allowed values: Inner, Left, Full.
Operator#
Operator · String · Optional · Default: Equal
How Column 1's value must relate to Column 2's. Numbers and dates compare as such, text ignoring case.
Allowed values: Equal, NotEqual, LessThan, LessThanOrEqual, GreaterThan, GreaterThanOrEqual.
Options#
Additional Columns 1#
AdditionalColumns1 · IEnumerable<String> · Optional · Default: Not specified in package metadata · Advanced
More columns of Data Table 1 that must equal the column at the same position in Additional Columns 2.
Additional Columns 2#
AdditionalColumns2 · IEnumerable<String> · Optional · Default: Not specified in package metadata · Advanced
The Data Table 2 columns matched by position with Additional Columns 1.
Output#
Output Data Table#
OutputDataTable · DataTable · Output
The resulting joined DataTable.
Retry and risk#
This activity is safe to retry: running it again after a transient failure does not repeat a side effect. If a run is interrupted and the outcome of a step is unknown, the step is never retried automatically (what to do). How activities declare this: characteristics, retries and risk.
Every activity also has the engine's common properties: Timeout and Continue On Error.
Related activities#
- Add Data Column
- Add Data Row
- Build Data Table
- Clear Data Table
- Filter Data Table
- Generate Data Table From Text
- Get Row Item
- Lookup Data Table
Generated from VeloPhex.System.Activities 0.7.1-rc.12. Category: Data Table. Keywords: datatable, join, inner, left, full, merge, relational.
Properties
Input
Options
Output
Retry and risk
Related activities