Stay organized with collections
Save and categorize content based on your preferences.
This page explains how to separate data from a field (a cell) into multiple
rows when you prepare data in the Wrangler workspace of the Cloud Data Fusion
Studio.
Separate delimited text
You can separate the values from a cell into new rows if the values are
separated by the following delimiters:
Comma
Tab
Pipe
Whitespace
Custom separator
If a cell doesn't contain the chosen delimiter, no new row is inserted.
To split values based on a delimiter, follow these steps:
On the Data tab, go to a column name and click the
arrow_drop_down
expander arrow.
Click Explode > Delimited text.
Choose a delimiter—for example Pipe.
Click Extract.
Wrangler splits the fields based on the selected delimiter and adds the
split-to-row directive to the recipe. When you run the data pipeline,
Cloud Data Fusion applies the transformation to all values in the column.
In this example, a dataset has a column of string values containing the comma
delimiter:
ID
Name
1
Lee,Lucian,Luka
2
Mahan,Noam
To divide the value into separate rows, Wrangler deletes the original column and
creates a new column with one row for each value. The other column values from
the original row are copied into the new rows:
ID
Name_1
1
Lee
1
Lucian
1
Luka
2
Mahan
2
Noam
Separate arrays
The flatten directive separates items in arrays, such as ["ELEMENT_1",
"ELEMENT_2", "ELEMENT_3"], into new rows. The other column values from the
original record are copied into the new records.
[[["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-03-21 UTC."],[[["This guide outlines the process of separating data within a single cell into multiple rows using the Wrangler workspace in Cloud Data Fusion Studio."],["The \"Explode \u003e Delimited text\" feature allows users to split values within a cell into new rows based on delimiters such as commas, tabs, pipes, whitespace, or a custom separator defined with a regular expression."],["When splitting delimited text, if a cell does not contain the specified delimiter, no new row will be inserted, and the original column is deleted and replaced by a new one."],["The \"flatten\" directive can be used to separate array items into new rows, while also copying the other column values from the original record into each new record."],["The `split-to-row` directive is added to the recipe when using the delimited text feature, applying the transformation to all values in the column when the data pipeline runs."]]],[]]
