Install
Download the Bot and follow the instructions to install it in your AAE Control Room.
Remove Excel Duplicates
This Bot removes duplicate record values and null values in selected column and returns processed records in a new excel file in the specified path
Top Benefits
- Custom range can be selected
- Remove duplicates
- Receive unique/ distinct values in the output
Tasks
- Removes duplicates from Excel
This Bot will remove duplicate record values and null values in the selected column and returns processed records in a new Excel file as specified in the Output path
Inputs: Input Excel File with path, Sheet Name, Column Name
Output: New Excel file without duplicate values