Replace Missing or Null Values in a Dataset

Replace missing or null values in a dataset column to cleanse your data. For example, if values are missing from a Month column, you might change them to January.

1. On the Home page, open a dataset or workbook.
   • Hover over the dataset, click Actions, and then select Open. In the Data Diagram or Join Diagram, right-click a data source and click Open to display the transform editor.
   • Hover over the workbook that contains the dataset, click Actions, then select Open, then click Data. In the Data Diagram or Join Diagram, right-click a data source and click Open to display the transform editor.
2. Hover over or select the column that you want to transform.
3. In the quality tile at the top of a column, double-click Missing or Null.
   
   

   
   Description of the illustration replace-missing-or-null.png

   
   
4. Enter a value to replace missing or null values, then press Enter. For example, if values are missing from a Month column, you might enter "January".
   Oracle Analytics adds a step to the left-hand Preparation Script panel.
5. To save your data preparation changes and apply them to your data, click Save.