Stay organized with collections
Save and categorize content based on your preferences.
This page explains how to add values to null and empty cells when you prepare
data in the Wrangler workspace of the Cloud Data Fusion Studio. If you have a
column that contains null or empty cells, you can specify a value to add to
those cells.
To specify a value to add to null or empty cells in a column, follow these
steps:
On the Data tab, go to a column name and click the
arrow_drop_down
expander arrow.
Select Fill null or empty cells.
Enter the value to add to each null or empty cell in the column.
Click Apply.
Wrangler fills each null or empty cell with the new value and adds the
fill-null-or-empty directive to the recipe. When you run the data pipeline,
the transformation is applied to all values in the column.
For example, in a column called Age, you replace the empty and null values
with the string N/Ausing the preceding steps. Wrangler updates the sample
dataset and adds the following directive to the recipe:
fill-null-or-empty :Age 'N/A'.
[[["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-04-12 UTC."],[[["This guide explains how to fill null or empty cells in a column within the Cloud Data Fusion Wrangler workspace."],["You can specify a value to replace null or empty cells in a selected column by using the \"Fill null or empty cells\" option."],["Applying this action updates the sample dataset and adds a `fill-null-or-empty` directive to the Wrangler recipe."],["The specified value will be applied to all null or empty cells in the selected column when the data pipeline is executed."]]],[]]