Filter Processor

Data filtering is required to refine the datasets so that you simply get what you need excluding other data that can be repetitive, irrelevant or sensitive. Different type of filters can be used to query results or other kind of information.

The Filter processor is used to display specific records by using filter criteria. For example, you can define the Filter rule: grade contains “software” and name contains “Mike”. The system will fetch all the records which meet this criteria.

Filter Processor Configuration

To add a Filter processor to your pipeline, drag the processor onto the canvas and right-click on it to configure.

FieldDescription
Config FieldsEnables to create local variables.
Message NameMessage on which filter rule is to be applied.
Filter Rule

Enables to create a filter rule.

The rule applies filter on the data based on the criteria provided.

For example, OrderMethodType is not null, Year less than 2050 and OrderMethodType matches Fax.

Add RuleEnables to configure additional rules.
Add group

Additional groups can be added using Add group link.

Rule(s) clubbed with either AND or OR operator that comes under a group i.e. Rule1 AND/OR Rule2.

For example, (grade contains software) AND (name contains Mike)

You need multiple groups for adding multiple operators.

DeleteEnables to delete added group or rule. 
Negate

If Negate is true, the filter criteria is evaluated as NOT of the given criteria.

If Negate is false, then the filter criteria is evaluated as it is. By default it is set to false.

Add New CriteriaEnables to configure additional criteria.
Up and Down arrowsEnables to move the groups and rules up and down.

Click on the NEXT button.

Click on the Save button If you do not wish to create a new template.

Top