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:

1. [Go to Wrangler workspace in Cloud Data Fusion](https://docs.cloud.google.com/data-fusion/docs/concepts/wrangler-overview#navigate-to-wrangler).
2. On the **Data** tab, go to a column name and click the arrow_drop_down expander arrow.
3. Select **Fill null or empty cells**.
4. Enter the value to add to each null or empty cell in the column.
5. 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/A`using the preceding steps. Wrangler updates the sample
dataset and adds the following directive to the recipe:
`fill-null-or-empty :Age 'N/A'`.

## What's next

- Learn more about [Wrangler directives](https://docs.cloud.google.com/data-fusion/docs/concepts/wrangler-overview#apply_directives).