Creating Filters

You can configure a filter by defining various filter conditions.

  1. In the Advanced Configuration tab, click Add Group Add Group icon. A new Filter Group row is added to the list.
  2. Use the Include selector to indicate whether or not this Filter should be included.
  3. Add a Filter condition by following these steps. You can add multiple groups and multiple conditions under each group.
    1. Click Add Condition Add Condition icon.
    2. Specify rules for the condition. You can define the conditions using one of the following:
      • Expression Builder: You can form conditions using all the operators given in the Expression Builder. The Expression Builder is used to define free flow text filter conditions. To define a filter condition using the Expression Builder, follow these steps:
        1. Click Exp. The Expression Builder dialog box is displayed.
        2. Select the required Dataset, Attribute and Runtime Parameters and operators. The resulting condition is displayed in the Condition field.
        3. Click Save Save iconto save the changes.
      • Tables: You can define conditions using the various columns of tables. The columns of the two tables are compared with each other using the required operators. To define conditions using tables, follow these steps:
        1. Select a Table or Data Forge for the left-hand side from the drop-down list.
        2. Select a Column for the left-hand side from the drop-down list.
        3. Select an Operator from the drop-down list.
        4. Select a Table or Data Forge for the right-hand side from the drop-down list.
        5. Select a Column for the right-hand side from the drop-down list.
      • Text: You can define filter conditions using text. A particular column in a table is compared with the input text using the required operators. To define filter conditions using text, follow these steps:
        1. Click Text.
        2. Select a Table or Data Forge for the left-hand side from the drop-down list.
        3. Select a Column for the left-hand side from the drop-down list.
        4. Select an Operator from the drop-down list.
        5. Enter the text in the field on the right-hand side.