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.

   Note:

   Oracle Analytics displays a Data Diagram for single-table datasets or a Join Diagram for multi-table datasets.
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.