Filter properties - Cloud

Talend Cloud Pipeline Designer Processors Guide

author
Talend Documentation Team
EnrichVersion
Cloud
EnrichProdName
Talend Cloud
task
Design and Development > Designing Pipelines
EnrichPlatform
Talend Pipeline Designer
Properties to configure to filter on the values of your fields.

Property

Configuration

Name

Enter a display name for the filter processor.

Description (optional)

Enter a description for the filter processor.

Filters

Field name

Select the field on which you want to apply a filter in the list.

Apply a function first (optional)

If needed, select the operation you want to apply while filtering the selected field.

Operator

Select the operator that will be used to filter the selected field.

Value

Type in the value of the selected field.

Select rows that match

In case you have defined multiple filters, select the type of matching to apply to the rows to be filtered: ALL, ANY or NONE.

Example: You have defined the two following filter criteria: age > 18 and name CONTAINS Tom:
  • If you select ALL, all the 18-years old named Tom will be returned.
  • If you select ANY, all the 18-years old and all the people named Tom will be returned.
  • If you select NONE, all the less-than-18-years old that are not named Tom will be returned.