Joining two columns

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:

1. Click the box to the right of the name of each column you want to join.

2. Click the drop-down button next to the column name.

3. Click Join two columns.

4. To set the order of the values in the new column, click the up/down arrows.
   
   

   Open

   

    

5. Choose a delimiter:

   • Comma

   • Pipe

   • Colon

   • Period

   • Dash

   • Underscore

   • Space

   • Custom delimiter

6. Give the new column a name.

7. Click Join.

Wrangler joins the columns and adds merge directive to the recipe. When you run the data pipeline, the transformation will be applied to all values in the column.

You can scroll to the far right to view the new column that contains all fields in both columns.