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, hover over a dataset that you own, click Actions, and then select Open.
   If the dataset contains a single table, you'll see the transform editor. If the dataset contains multiple tables, you'll see the Join Diagram. In the Join Diagram, right-click a data source and click Open to display the transform editor.
   

   
   Description of the illustration data-preparation-toggle-options.png

   
   
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.