Remove List Duplicates

The Remove List Duplicates action A feature that supplies the instructions in a botflow. removes rows from a list in a botflow A file that stores the actions and variables designed to automate tasks. that have the exact same values in the list columns.

Using the Remove List Duplicates action, you can remove list duplicates from:

  • A list of imported data.
  • Within a list in a botflow.

Some examples of applications for the Remove List Duplicates action:

Add a Remove List Duplicates action to a botflow

This example provides the steps necessary to add a Remove List Duplicates action to a botflow.

To add a Remove List Duplicates action to a botflow:

  1. On the Actions List, click Lists and then click Remove List Duplicates from the Values list.

    2. The Action Builder window for Remove List Duplicates displays.

  2. Set the Remove List Duplicates settings:

    3. General

    • List: Type a list name in the List field.
    • Column: Select a column option from the drop-down.
      • All columns: Removes the row if a duplicate is found in every column.
      • Exact column: Removes the row if a duplicate is found in the specified column.

  3. If needed, adjust the Run Error Task settings to fine tune how the action runs.
  4. If needed, adjust the Run Switch setting to create the action without running it.
  5. Optionally, add an action note.
  6. Click OK to add the Remove List Duplicates action to the botflow.
Field or button Description
Remove List Duplicates Options/Settings

General

  • List: Type a list name in the List field, select a list from the drop-down, or use the Expression Builder to build the action settings using variable or other token values.
  • Column: Select a column option from the drop-down.
    • All columns: Removes the row if a duplicate is found in every column.
    • Exact column: Removes the row if a duplicate is found in the specified column. Type a list column name in the Column field, select a list column from the drop-down, or use the Expression Builder to build the action settings using variable or other token values.
Run error task
  1. Click Run error task.
  2. Open the On Error drop-down list and select the required setting:
    • Run error task: A botflow containing an error task automatically runs the error task in the event of an error. If the botflow does not contain an error task, the botflow stops in the event of an error.
    • Stop on error: The botflow stops in the event of an error.
    • Ignore errors: The action is skipped in the event of an error and the botflow attempts to execute the next action
  1. Click X to close the drop-down and save the setting.
Note

(Optional) Type a Note to document any special instructions or functionality.    
Run Switch

The Run Switch toggle controls how Nintex RPA runs an action when adding or editing an action in a botflow.

  • Run: To run the action automatically when you click OK, turn the toggle to Run.

  • Don't Run: If you do not want to run the action automatically when you click OK, turn the toggle to Don't Run.
OK/Cancel Click OK to save the action or click Cancel to discard the action or any changes.