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

CONFIGURATION FILTERS Input

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

Optionally select a function to apply

If needed, select the operation you want to apply while filtering the selected field:
  • NONE: Does not apply any functions while filtering.
  • TO ABSOLUTE VALUE: Calculates the absolute value for all the numeric values in the field.
  • TO LOWER CASE: Converts all the text in the field to lower case.
  • TO UPPER CASE: Converts all the text in the field to upper case.
  • FIRST CHARACTER TO LOWER CASE: Puts the first letter of every word in the field to lower case.
  • FIRST CHARACTER TO UPPER CASE: Puts the first letter of every word in the field to upper case.
  • LENGTH: Extracts the number of digits from a value in the field.
  • COUNT: Counts the number of values in the 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 CONTAINSTom:
  • 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.
INFO Description (optional)

Enter a description for the processor.

To rename the processor, click the Edit icon next to the default name of the processor.