Merge Data Table

Merges a source DataTable into a destination DataTable.

Behaviour

Risk: Low · Idempotent: No · Safe to retry: No · Recovery: Not replayed after a crash

Package System activities VeloPhex.System.Activities 0.7.1-rc.12 · Supported (Core profile) · type id velophex.system.mergeDataTable

Properties#

Input#

Source#

Source · DataTable · Required · Default: Not specified in package metadata

The source DataTable to read from.

Destination#

Destination · DataTable · Required · Default: Not specified in package metadata

The destination DataTable to merge into.

Missing Schema Action#

MissingSchemaAction · String · Optional · Default: Add

Action to take when source columns are missing in destination: Add, AddWithKey (also the primary key), Ignore, or Error.

Allowed values: Add, AddWithKey, Ignore, Error.

Output#

Output Data Table#

OutputDataTable · DataTable · Output

The destination DataTable with merged rows.

Retry and risk#

This activity is not marked safe to retry: if it fails partway, check whether its work already happened before running it again. 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
• Join Data Tables

Generated from VeloPhex.System.Activities 0.7.1-rc.12. Category: Data Table. Keywords: datatable, merge, combine, union, append.

Properties

Input

Output

Retry and risk

Related activities