Help Centre › Building Processes
This article describes the RPA Excel functionality to find duplicates.
For a full list of available functions, please read EXCEL functions.
Description
The EXCEL Find duplicates function allows you to find duplicates.
Setting it up
To use the EXCEL Find duplicates function, follow these instructions:
{{popups:rpas/add:action=excel-duplicates}}
Once on a process map:
- Navigate to the process where you would like to add the EXCEL Find duplicates function
- Click on the green button’s drop-down (right side of the green button labelled “Process”)
- On the menu that appears, click on the “+ Activity” item
- From here you can select the EXCEL Find duplicates option
- Click "Add" once you are done
Input parameters
| Parameter | Required | Type | Default | Description |
|---|---|---|---|---|
| Sheet | Yes | Text | - | The name of the sheet |
| Columns | Yes | Textarea | - | Column names to check for duplicates, separated by line breaks |
| Remove whitespace | No | Switch | Off | Trim whitespace from values before comparing |
| Convert to lower case | No | Switch | Off | Convert values to lower case before comparing |
Output variables
This action does not produce output variables.
Errors
| Error | Description |
|---|---|
| File not open | The Excel file must be open |
| Sheet not found | The specified sheet does not exist |
Tips
- Duplicate rows are removed based on the specified columns
- Enable trim and lower case for more accurate duplicate detection