Test Tool

Test Tool

Version:
Current
Last modified: March 11, 2020

The Test tool verifies data or processes in a workflow. Since the Test tool accepts multiple inputs, with a single Test tool you can create multiple tests and test multiple sets of data and processes. The tool notifies you with a descriptive error message if your test criteria are not met.

Use the Test tool to verify data before writing results to a database.

Tool Configuration

When the tool is first placed on the canvas, an empty list is displayed in the Configuration window.

To add a new test to the list:

Because this tool includes an expression editor, an additional input anchor displays when the tool is used in an app or macro workflow. Use the Interface tools to connect to a Question anchor. See Interface Tools.

  1. Click Add to open the Add Test window.
  2. Type a test name in Test Name.
  3. Click Input Connection, and select the input connection to test.
  4. Click Test Type, and select a test.
    • Record count matches specific value: The test fails if the record count does not match the value in Test Value.
    • Record count matches other input's record count: The test fails if the record count in each input does not match the value in Test Value.
    • Expression is true for all records: The test fails if one or more records do not match the expression in Test Value.
    • Expression is true for first record: The test fails if the first record does not match the expression in Test Value.
  5. In Test Value, type the value or select the input you want to test.
  6. If Test Type is an expression, click to create an expression. See Expression Editor.
  7. Click OK to confirm your new test.

To edit an existing test:

  1. In the list, select the test and click Edit to open the Edit Test window. You can also double-click the test.
  2. Adjust the fields as desired.
  3. Click OK to confirm changes, or Cancel to revert to the original test configuration.

To delete an existing test:

  1. In the list, select the test.
  2. Click Delete. The test is deleted without a confirmation screen.

Before running, use Don't report errors if there are other errors in the workflow to determine the error behavior of the workflow. The option is selected by default, so test errors only report if there are no other errors in the workflow.

If you want to see errors from the Test tool regardless of other errors in the workflow, such as if you have known errors that you use for validation, you can deselect the option to have the Test tool produce errors, regardless of errors being present in the rest of the workflow.

Was This Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support.