Replace Null Values

In this document, you’ll learn how to use the Replace Null Values function in Astera Dataprep to handle missing data by replacing null strings or numerics with default values.

1. To begin, click on the Cleanse option in the toolbar and select Replace Null Values from the drop-down.

1. This will open the Recipe Configuration – Replace Null Values panel.

1. In this panel, you’ll configure the following options:

• Column Section Properties:

  • Apply to entire dataset: The changes will be applied to the entire dataset.

  • Apply to specific column(s): Allows you to apply changes to selected columns only.

• Replace Nulls:

  • Null strings with blanks: Replaces all null strings with blank entries.

  • Null numerics with zeros: Replaces all null numeric values with 0.

1. Once you’re done, click Apply. In the Grid, you’ll see that all specified null values have been replaced accordingly.

1. Alternatively, you can right-click on a column in the Grid and go to Cleanse > Replace Null Values. The same configuration panel will appear with the column already selected. Make any changes you need and click Apply to update your data.