Definition and Usage
This command removes duplicate rows from a specific range in Excel. It allows you to identify and eliminate duplicate entries based on specific columns in your worksheet, helping to clean and organize your data efficiently.
Parameter Values
Input parameters
Parameter | Description | Possible Values | Required | Options / Notes |
Excel instance | Please select an Excel instance to identify the instance to operate on | Excel object | Yes | Must be created via the "Launch Excel" or "Get active Excel worksheet" command |
Worksheet name | Specify the worksheet name | Text | No | Leave blank for the active worksheet |
Compare columns | Compare these columns to detect duplicates | Column identifiers | No | Enter column names (A or 1); Multiple columns can be specified as A,B,C or A:C; If not entered, it means all columns |
Start row number | The row to start checking for duplicates | Number | Yes | Use 1 for the first row, or -1 for the last row |
Error handling
Parameter Name | Description |
Throw error & stop | When an error occurs, the action will trigger an error and stop the execution of the entire app. |
Retry command | If an error occurs, the action will retry the command in an attempt to resolve the issue and continue the process. |
Ignore error & continue | When an error occurs, the action will be ignored, and the workflow will continue without interruption. |
Variables produced
This action doesn't produce any variables.
Using Variables in Conditions
You can use variables in the parameter fields by clicking the {x} icon or inserting a variable reference. This allows you to dynamically set values such as worksheet names, column ranges, or row numbers based on previous operations in your workflow.
Notes
Before using this command, ensure that a valid Excel instance has been created and is accessible.
The command will remove all but the first occurrence of duplicate rows based on the specified columns.
If no columns are specified for comparison, the command will check all columns to identify duplicates.
The start row parameter helps you preserve headers or other important data at the top of your worksheet.
For large datasets, this operation might take some time to complete.