This page explains how to add values to null and empty cells when you preparedata in the Wrangler workspace of the Cloud Data Fusion Studio. If you have acolumn that contains null or empty cells, you can specify a value to add tothose cells.

To specify a value to add to null or empty cells in a column, follow thesesteps:

1. Go to Wrangler workspace in Cloud Data Fusion.
2. On theData tab, go to a column name and click thearrow_drop_downexpander arrow.
3. SelectFill null or empty cells.
4. Enter the value to add to each null or empty cell in the column.
5. ClickApply.

Wrangler fills each null or empty cell with the new value and adds thefill-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 calledAge, you replace the empty and null valueswith the stringN/Ausing the preceding steps. Wrangler updates the sampledataset and adds the following directive to the recipe:fill-null-or-empty :Age 'N/A'.

What's next

• Learn more aboutWrangler directives.