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.
    • Select the dataset, click the Actions menu, and then select Open. In the Data Diagram or Join Diagram, right-click a data source and click Open to display the transform editor.
    • Select the workbook that contains the dataset, click the Actions menu, 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.
  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.