Setting Classifier Filter Conditions

You can choose to transform specific data from a source classifier to a target classifier in the ClassifierMap Designer. This feature enables you to set a filtering condition at the classifier level to conditionally transform this data.

Note: For RDMS as a source, the filtering condition can be set only for the primary key column.

To set a filter at the classifier level

  1. In the ClassifierMap Designer, hover the mouse over the target classifier, and click the filter icon () displayed on the right side of the classifier.

    The Filter: <classifier name> window appears.

  2. To set a filtering condition, either double-click the source variables and then the operators from the list, or manually drag or type the source variables and then the operators as required.

    Note: If you use more than one operator to define the filter condition, the order in which the result is calculated, is based on the arithmetic symbol priority rule.

  3. Click Validate to validate the filter condition.

    If the validation is successful, a success notification appears. If the validation fails, an error message is displayed. Check the message for errors, and redefine the filter condition.

  4. Click Save to save the filter condition.

    If the filter condition is invalid, an error message is displayed. A warning message also appears. Click Yes to save the expression and close the window. Click No to close the warning message and redefine the filter condition.

  5. To test if the filter condition that you have applied works fine

    1. In the Evaluation pane, provide the test values in the Input area.

      Note: If you enter an invalid value, a warning sign appears adjacent to the Input field.

    2. Click Test to view the result in the Output area.

      Note: The Test button is enabled only after the expression is successfully validated.

    If the input matches the filter condition, the result is "True"; else, it is "False".

  6. Click OK.

You can click Cancel to cancel the process.

A filtering condition is set between the source classifier and the target classifier. In the ClassifierMap Designer, the filter icon () is displayed at the top left of the target classifier. You can hover the mouse over the icon to view the filter condition in a tooltip. Additionally, you can open the filter window by clicking the filter icon ().

Note: To remove the filter, delete the filter condition from the Filter:<classifier name> window.