Yang, Tong 3f5759eed2 MRS comp-lts 2.0.38.SP20 version

Reviewed-by: Hasko, Vladimir <vladimir.hasko@t-systems.com>
Co-authored-by: Yang, Tong <yangtong2@huawei.com>
Co-committed-by: Yang, Tong <yangtong2@huawei.com>

2023-01-19 17:08:45 +00:00

8.5 KiB

Raw Permalink Blame History

Filter Rows

Overview

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

Input and Output

Input: fields used to create filter conditions
Output: none

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

When the condition logic is AND, if no filtering condition is added, all data becomes dirty data; if the original data meets all the added filtering conditions, the current line becomes dirty data.
When the condition logic is OR, if no filter condition is added, all data becomes dirty data; if the original data meets any of the added filter conditions, the current line becomes dirty data.

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:

Parent topic: Conversion Operators

8.5 KiB Raw Permalink Blame History