Functional and Logical Operators

To establish multiple filter conditions, use standard mathematical operators (that is, +, -, *, or /), logical operators (for example, AND, OR, or NOT), and parentheses to define the required logic.

To filter a dataset, follow these steps:

1. Click the Filter Elements icon in the Transforms area.

   The system adds the icon to the next available square in the Transforms area grid.

2. Link the Join icon to the Filter Elements icon.
3. Double-click the Filter Elements icon.

   The Edit Filter dialog box displays.

4. Enter the name of the filter in the Name field.
5. Select the desired attribute and click Insert Attribute in the Available Attributes area. The system adds the attribute to the Filter Criteria field.
6. Click the cursor in the Filter Criteria area after the attribute to begin building the filter.
7. Follow these steps:
   • Enter the equality operator.
   • Enter the attribute value, another attribute, or a threshold.
   • Enter the attribute value preceded by the applicable equality operator.
8. Type [space] and or or to start the next constraint.
9. Click Ok after entering the required filters.