In Wrangler, you can join two columns with the same or different data types. The join results in a new column that contains all fields in both columns. You cannot join columns of type Boolean and Bytes with any other column.
To join two columns, follow these steps:
Click the box to the right of the name of each column you want to join.
Click the drop-down button next to the column name.
Click Join two columns.
To set the order of the values in the new column, click the up/down arrows.
Choose a delimiter:
Comma
Pipe
Colon
Period
Dash
Underscore
Space
Custom delimiter
Give the new column a name.
Click Join.
...