◄Show Table of Contents

Test Tool

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.

Configure the tool

1. Click Add.
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.

If Test Type is an expression, click to create an expression. See Expression Editor.

6. Click OK.

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.

Alteryx.com | Community | Customer Support | Documentation Feedback

©2018 Alteryx, Inc., all rights reserved. Allocate®, Alteryx®, Guzzler®, and Solocast® are registered trademarks of Alteryx, Inc.