Filter Rows

Overview

This Filter Rows operator filters rows that contain triggering conditions by configuring logic conditions.

Input and Output

Parameter Description

Table 1 Operator parameters description

Parameter

Description

Type

Mandatory

Default Value

Condition logic connector

Condition logic connector. The options include AND and OR.

enum

Yes

AND

Conditions

Filter condition information:

  • input field name: Names of the input fields. Set this parameter to the names of the fields generated in the previous conversion step.
  • operator: Operator
  • comparative value. You can directly enter the value of a field referenced in the #{Existing field name} format.

map

Yes

None

Data Processing Rule

Example

Use the CSV File Input operator to generate two fields A and B.

The following figure shows the source file.

Configure the Filter Rows operator to filter lines that contain test.

After the conversion, enter the original fields. The result is as follows: