It’s been a while since I’ve done an Alteryx challenge. Today, it’s time to learn a new tool in Alteryx, Test. Use Test to verify 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.

Below is an Alteryx challenge that requires the checking of some conditions:

All you need to do is to employ Test tool. Another alternative to this is Error Message tool. But today, let explore Test tool.

When you click on the configuration window, just click on add to set up conditions.

Next, enter the name of the condition, Input Connection, and Test Type and Test Value.

There are 4 test types:

· Record Count Matches Specific Value: The test fails if the record count does not match the value entered in the Test Value field.

· Record Count Matches Other Input's Record Count: The test fails if the record count in each input does not match the value entered in the Test Value field.

· Expression is True for All Records: The test fails if one or more records do not match the expression entered in the Test Value field.

· Expression is True for First Record: The test fails if the first record does not match the expression entered in the Test Value field.

After setting up all conditions, let just plug this tool into the workflow.