Filter properties - Cloud

Talend Cloud Pipeline Designer Processors Guide
Version
Cloud
Language
English
Product
Talend Cloud
Module
Talend Pipeline Designer
Content
Design and Development > Designing Pipelines
Last publication date
2024-02-26
Properties to configure to filter on the values of your fields.
Configuration
Property 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: 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 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.
Info

Property

Configuration
Description (optional)

Enter a description for the processor.

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