Remove duplicate row
This activity helps to remove the duplicate row in the table automatically.
Technical reference:
|
|
INPUT |
Table: Specify the datatable variable that has duplicate rows in the table. |
|
MISC |
Display Name: Displays the name of the activity. You can also customize the activity name to help troubleshoot issues faster. This name will be used for logging purposes |
|
|
SkipOnError: It specifies whether to continue executing the workflow even if it throws an error. This supports only Boolean value “True or False” True: Continues to execute the workflow irrespective of any error thrown. False: Stops the workflow if it throws any error |
||
|
Version: It specifies the version of the DataTable automation feature in use. |
* Mandatory fields to execute the workflow
Example:
The following explains how to remove duplicate rows from table. Here we are going to automate with generate table, table viewer, and remove duplicate row activities.
1. Drag and drop the Remove duplicate row activity to the workflow.
2. Connect it below to the Generate table activity.
3. Add table viewer activity and connect it below the Add new row activity.
4. Enter the variable name and title for the activity.
5. Enter the datatable variable “Test” in the Table from the properties panel of Remove Duplicate row.
6. Add another table viewer activity and connect it below the Remove duplicate row activity.
7. Enter the variable name and title for the activity.
8. Now, execute the workflow.
The bot will identify the duplicate rows and removes it from the table.