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-08-29 UTC."],[[["\u003cp\u003eThis guide outlines the process of separating data within a single cell into multiple rows using the Wrangler workspace in Cloud Data Fusion Studio.\u003c/p\u003e\n"],["\u003cp\u003eThe "Explode > 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.\u003c/p\u003e\n"],["\u003cp\u003eWhen 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.\u003c/p\u003e\n"],["\u003cp\u003eThe "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.\u003c/p\u003e\n"],["\u003cp\u003eThe \u003ccode\u003esplit-to-row\u003c/code\u003e 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.\u003c/p\u003e\n"]]],[],null,["# Explode data from fields\n\nThis page explains how to separate data from a field (a cell) into multiple\nrows when you prepare data in the Wrangler workspace of the Cloud Data Fusion\nStudio.\n\nSeparate delimited text\n-----------------------\n\nYou can separate the values from a cell into new rows if the values are\nseparated by the following delimiters:\n\n- Comma\n- Tab\n- Pipe\n- Whitespace\n- Custom separator\n\nIf a cell doesn't contain the chosen delimiter, no new row is inserted.\n\nTo split values based on a delimiter, follow these steps:\n\n1. [Go to Wrangler workspace in Cloud Data Fusion](/data-fusion/docs/concepts/wrangler-overview#navigate-to-wrangler).\n2. On the **Data** tab, go to a column name and click the arrow_drop_down expander arrow.\n3. Click **Explode \\\u003e Delimited text**.\n4. Choose a delimiter---for example **Pipe**.\n5. Click **Extract**.\n\n | **Note:** If you select Custom separator, define the delimiter with a regular expression.\n\nWrangler splits the fields based on the selected delimiter and adds the\n`split-to-row` directive to the recipe. When you run the data pipeline,\nCloud Data Fusion applies the transformation to all values in the column.\n\nIn this example, a dataset has a column of string values containing the comma\ndelimiter:\n\nTo divide the value into separate rows, Wrangler deletes the original column and\ncreates a new column with one row for each value. The other column values from\nthe original row are copied into the new rows:\n\nSeparate arrays\n---------------\n\nThe `flatten` directive separates items in arrays, such as `[\"ELEMENT_1\",\n\"ELEMENT_2\", \"ELEMENT_3\"]`, into new rows. The other column values from the\noriginal record are copied into the new records.\n\nWhat's next\n-----------\n\n- Learn more about [Wrangler directives](/data-fusion/docs/concepts/wrangler-overview#apply_directives)."]]
