Skip to content

Remove Duplicates Activity

The Remove Duplicates activity enables users to eliminate redundant rows within specified columns of an Excel spreadsheet. This activity streamlines data cleaning processes by identifying and removing duplicate entries, thereby ensuring data integrity and accuracy.

Field Description Requirement
Excel Name The reference name of the Excel file where the operation will be performed. This file must be previously opened or created by another activity. Required
Sheet Name The name of the specific sheet within the Excel file. If left blank, the activity defaults to the first sheet. Optional
Row Specifies the starting row number for the duplicate removal operation. If left blank, the activity operates across all rows or based on the Column parameter. Optional
Column Specifies the column(s) by name (e.g., "A", "B") or index (e.g., "1", "2") where duplicate values will be identified and removed. If left blank, the activity operates across all columns or based on the Row parameter. Optional

Action Types & Examples

Excel Name Configuration

  • Format: String
  • Example Result: newExcel

Sheet Name Configuration

  • Format: String
  • Example Result: Sheet1

Row Configuration

  • Format: Digit (Integer)
  • Example Result: 1

Column Configuration

  • Format: String or Digit (Integer)
  • Example Result: A

Implementation Examples

Field Setup - Excel name: newExcel - Sheet name: Sheet1 - Row: 1 - Column: A

Execution Parameters - To remove duplicates in Sheet1 of newExcel based on column A: RemoveDuplicates(excelName: "newExcel", sheetName: "Sheet1", column: "A") - To remove duplicates in myReport across all columns, considering only row 1: RemoveDuplicates(excelName: "myReport", row: "1") - To remove duplicates in the first sheet of dataWorkbook based on column B: RemoveDuplicates(excelName: "dataWorkbook", column: "B")

Technical Notes

The Sheet Name parameter is optional; if left blank, the activity will operate on the first sheet of the specified Excel file. To remove duplicates based solely on column values across all rows, leave the Row parameter blank and specify the Column. When referencing columns by index, ensure consistency with Excel's standard 1-based indexing (e.g., column 'A' is 1, 'B' is 2) for user input.