Concatenate

The Concatenate step allows you to combine values from multiple columns into a single new column.

Step parameters

• Columns to concatenate column(array)*: Select two or more columns to concatenate

• Separator string or void: a character or a string of characters to be used as a separator between concatenated columns. Can be left empty if no separator has to be used.

• New column name string* :Enter a name for the new column that will contain the concatenated values

Example

Input

Text - concatenate

Configuration

{
    "columns": ["first_name", "last_name"],
    "separator": " ",
    "new_column_name": "full_name"
}

Result

Text - concatenate output