Skip to main content

Remove Duplicates

Deletes duplicate rows in a specified range

Input​

  • Range: The range of cells to remove duplicates from
    • Type: System.String
  • Has Headers: Indicates whether the range has headers or not.
    • Type: System.Boolean

Details​

  • This activity can only be used within the Use Excel File activity. Excel application must be installed on the machine where the process will run.
  • Columns to compare - The columns to be compared in order to determine if a row is duplicate. If the values in all of the indicated columns are the same as a previous row, it is considered a duplicate.
  • To indicate specific columns to compare, select Compare individual columns, and then click Add Column to add a column to the comparison. To compare all the columns in the selected range, select Compare all columns. This disables the Add Column option and ignores any previously added columns.