Subtract List

The Subtract List action An instruction within a botflow. removes one list from another leaving only the difference in a botflow Automated steps that you can design for each bot that will run..

Example: List 1 contains 1, 2, 3, 4, 5, 6, 7, 8, 9. List 2 contains 1, 2, 3, 4, 5, 6. Save to List contains 7, 8, 9.

Using the Subtract List action, you can subtract one list from another list of:

  • Imported data.
  • Lists within a botflow.

Some examples of applications for the Subtract List action are:

  • Subtract lists from each other that are created in the Nintex RPA LE Botflow Pane.
  • Subtract a list of items extracted from lists created using the Create List action.

Add a Subtract List action to a botflow

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

To add a Subtract List action to a botflow:

  1. On the Actions List, click Lists and then click Subtract List from the List list.

    2. The Action Builder window for Subtract List displays.

  2. Set the Subtract List settings.

    3. General

    • List 1: Type a list name in the List 1 field.
    • List 2: Type a list name in the List 2 field.
    • Column: Select a column option from the drop-down:
      • All columns: Subtracts the list row when a match is found in every column.
      • Exact column: Subtracts the list row when a match is found in the specified column.
    • Save to: Type a list name in the Save to field.
    • Overwrite: Overwrites a file of the same name.

  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 Subtract List action to the botflow.

Action Builder field and button descriptions

Field or button Description
Subtract List Options/Settings

General

  • List 1: Type a list name in the List 1 field, select a list from the drop-down, or use theExpression Builderto build the action settings using variable or other token values.
  • List 2: Type a list name in the List 2 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: Subtracts the list row when a match is found in every column.
    • Exact column: Subtracts the list row when a match 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.
  • Save to: Type a list name in the Save to field, select a list from the drop-down, or use the Expression Builder to build the action settings using variable or other token values.
  • Overwrite: Overwrites a file of the same name.
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 Bot runs an action when adding or editing an action in a botflow.

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

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