Creating a filter using a validation rule

Use a ValidateGroup function to filter out rows containing an invalid element.

In this example, create a filter to display only the employee in the Denver location.

Procedure

Select the row (0:*) element from the Input (XML) table and open the Validate tab.
From the Functions tab, select ValidateGroup and drop it in the Validate tab.
Double-click on ValidateGroup.
1. Enter TEST in the Message field.
2. Enter a number, for example, 11.
In the Data section, drag-and-drop the input element that you want to validate. In this example, use Location.
Select Location from the Input (XML) table and open the Validate tab.
Insert a validation function that returns a Boolean. In this example, select the Contains function from the Functions palette.
Double-click Contains and enter Denver.
Drag-and-drop the Location element from the Input (XML) table in the Input Value section.
Select the row (0:*) element from the Output (XML) tab.
In the SimpleLoop, add the IsValid function in Filter section.
Click Test Run to display the employee in Denver.

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!