ConcatColumn / String Layer

Concatenate (join) two string columns, with an optional separator between them. Similar to pandas str.cat() or Python's string join operations. Useful for:

Combining name fields (first name + last name)
Creating full addresses (street + city)
Building composite identifiers
Joining hierarchical categories

Table

SelectLeft

column

The left column (SelectLeft) in the concatenation. Examples:

First name in a full name
Country code in a product code
Domain in a full URL

SelectRight

column

The right column (SelectRight) in the concatenation. Must contain strings. Examples:

Last name in a full name
Sequential number in a product code
Path in a full URL

Separator

string

Optional text to insert between the values from SelectLeft and SelectRight. Common separators:

Space ( ) for names
Hyphen (-) for codes
Slash (/) for paths
Empty string () for direct concatenation

Name for the new column. If not provided, the system generates a unique name. If AsColumn matches an existing column, the existing column is replaced. The name should follow valid column naming conventions.