Remove Duplicate Rows

Removes duplicate rows from a DataTable, producing a new DataTable with unique rows.

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.removeDuplicateRows

Properties#

Input#

Data Table#

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

The DataTable from which duplicate rows will be removed.

Output#

Output Data Table#

OutputDataTable · DataTable · Output

The newly produced DataTable containing only distinct rows.

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
• Join Data Tables

Generated from VeloPhex.System.Activities 0.7.1-rc.12. Category: Data Table. Keywords: datatable, duplicate, distinct, unique, deduplicate.

Properties

Input

Output

Retry and risk

Related activities