Description

Removes the duplicate rows from a specified data table.



Attributes

Output

  • DataTable - The data table with removed duplicate rows.

Input

  • DataTable - The data table you want to remove duplicate rows from.

Common

  • ContinueOnError - The Boolean value to specify whether to continue executing the next activities even if there is an error thrown on this activity.

Misc

  • DisplayName - Renames the activity.


Example

  1. Create a DataTable variable called dt.
  2. Add a Generate Data Table inside a Sequence, and in the DataTable field under Properties, add dt.
  3. In the ColumnSeparators field under Properties, write ";", and in the NewLineSeparator field, write "|".
  4. In the Input field, type "1; Nicole; 32|1; Nicole; 32|2; John; 25|3; Michael; 29". This would be the sample values inside the data table.
  5. Add a Remove Duplicate Rows activity.
  6. In the DataTable field, add dt. The use case should look as the following screenshot:



After execution, the duplicate rows in dt data table should be removed. In this sample, the row "1, Nicole, 32" should be removed.