Test tool icon

Test Tool

Last modified: September 09, 2021

Docs are available before the release of Designer Cloud so you can get a sneak peek. This content might change between now and the official release.

One Tool Example

Test has a One Tool Example. Go to Sample Workflows to learn how to access this and many other examples directly in Alteryx Designer Cloud.

Use Test to verify data or processes in a workflow. Because the Test tool accepts multiple inputs, you can create multiple tests and test multiple sets of data and processes with a single Test tool. 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.

Configure the Tool

Add Test

To add a test to the list...

  1. Select Add Test.
  2. To rename the test, double click the assigned test name and enter a new name.
  3. Select the Input Connection to test.
  4. Select Test Type, and select a test.
    • Record Count Matches Specific Value: The test fails if the row count does not match the value entered in Value.
    • Record Count Matches Other Input's Record Count: The test fails if the row count in each input does not match the Value.
    • Expression is True for All Rows: The test fails if 1 or more rows do not match the expression entered in the expression editor.
    • Expression is True for First Row: The test fails if the 1st row doesn't satisfy the expression entered in the expression editor.
  5. Enter the Value to select the input you want to test.
  6. If the Type of Test is an expression, create an expression.

Delete Test

To delete an existing test, select the Remove icon (trashcan).

Errors in the Workflow

Before you run the workflow, use Report Errors Even if the Workflow Contains Other Configuration Errors to determine the error behavior of the workflow. If checked, the test errors report regardless of errors being present in the rest of the workflow (for example, if you have known errors that you use for validation).

Was This Page Helpful?

Running into problems or issues with your Alteryx product? Visit the Alteryx Community or contact support. Can't submit this form? Email us.