Version

    Merge columns

    The Merge columns step can be used to merge data from multiple columns into a single column.

    Parameters
    • Columns to merge: required, select the columns to be merged in the sequence you want the values combined. You can change the column sequence by drag and dropping by the grip on the left of a column field.

    • Delimiter: optional, specify a delimiter to be used between merged values.

      • Both single characters (including a space) and multiple characters can be used as delimiters.

      • You can also select newline or tab characters as delimiters from the dropdown list.

    • Ignore blanks: checked by default. When checked, empty values are disregarded and not included in the merged values. This parameter is ignored when no delimiter is specified.

    • Output column name: required, enter the name of the new column. The name defaults to New column.

    • Position of the output column:

      • As the last column

      • As the first column

      • After column

    Examples
    Street City Postal Code Delimiter Ignore blanks Result

    Baker Street 221b

    NW1 6XE

    London

    (No delimiter specified)

    Any

    Baker Street 221bNW1 6XELondon

    Baker Street 221b

    No Value

    London

    (No delimiter specified)

    Any

    Baker Street 221bLondon

    Baker Street 221b

    NW1 6XE

    London

    ,

    Any

    Baker Street 221b,NW1 6XE,London

    Baker Street 221b

    No Value

    London

    ,

    Yes (checked)

    Baker Street 221b,London

    Baker Street 221b

    No Value

    London

    ,

    No (unchecked)

    Baker Street 221b,,London

    Baker Street 221b

    "    " (4 spaces) [1]

    London

    ,

    Any

    Baker Street 221b,    ,London

    Baker Street 221b

    NW1 6XE

    London

    \n [2]

    Any

    Baker Street 221b
    NW1 6XE
    London

    Baker Street 221b

    NW1 6XE

    London

    \\ [3]

    Any

    Baker Street\221b\NW1 6XE\London

    1

    Spaces are not considered an empty value.

    2

    You can use escape sequences (\n, \t, etc.) as delimiters.

    3

    To use a backslash itself as a separator, enter two backslashes.