Stay organized with collections
Save and categorize content based on your preferences.
This page explains how to join column values and swap column names when you
prepare data in the Wrangler workspace of the Cloud Data Fusion Studio.
Join two columns
The Wrangler workspace supports joining two columns of the same or different
data types. The JOIN operation's output is stored in a new column containing
the joined fields from both columns. Wrangler doesn't support joining columns of
the boolean and bytes data types with other columns.
On the Data tab, select the checkbox by two column names.
Click the
arrow_drop_down
expander arrow by one of the column names.
Select Join two columns, and select an option—for example, Custom
selection.
Choose an order, delimiter, and new column name for the JOIN operation's
output.
Click Join.
Wrangler joins the columns and adds the merge directive to the recipe. When
you run the data pipeline, the transformation is applied to all values in the
column.
Swap two column names
The Wrangler workspace supports swapping (or interchanging) two column names.
Only the column names interchange, the values in the column rows don't change.
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],["Last updated 2025-08-07 UTC."],[[["\u003cp\u003eThis page describes how to join two columns and swap two column names within the Wrangler workspace in Cloud Data Fusion.\u003c/p\u003e\n"],["\u003cp\u003eJoining columns combines the values of two selected columns into a new column, excluding boolean and bytes data types.\u003c/p\u003e\n"],["\u003cp\u003eTo join columns, you select the two columns, choose the "Join two columns" option, specify the order, delimiter, and new column name, then apply the \u003ccode\u003emerge\u003c/code\u003e directive.\u003c/p\u003e\n"],["\u003cp\u003eSwapping column names exchanges the names of two selected columns without altering their values, using the \u003ccode\u003eswap\u003c/code\u003e directive.\u003c/p\u003e\n"],["\u003cp\u003eTo swap columns you select the two columns, then choose the "Swap two column names" option.\u003c/p\u003e\n"]]],[],null,[]]