Updated on 2023-04-28 GMT+08:00

Concat Fields

Overview

The Concat Fields operator concatenates existing fields by using delimiters to generate new fields.

Input and Output

  • Input: fields to be concatenated
  • Output: new fields

Parameter Description

Table 1 Operator parameter description

Parameter

Description

Type

Mandatory

Default Value

Output field name

Name of a field generated after concatenation.

string

Yes

None

Delimiter

Concatenation character. The value can be blank.

string

No

Empty string

Fields to be merged

Names of fields to be concatenated.

field name must be set to the names of fields generated in the previous conversion step. Multiple field names can be added.

map

Yes

None

Data Processing Rule

  • Use delimiters to concatenate the fields specified by Fields to be merged in order and assign the output to Output field name.
  • If the value of a field is null, the value is changed to an empty string and then concatenated with other field values.

Example

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

The following figure shows the source file.

Configure the Concat Fields operator, set Delimiter to blank space, and generate field D.

After concatenation, fields A, B, C, and D are generated, as shown in the following figure.