Delete a Column in a Dataset

Delete a column to remove it from the dataset stored in Oracle Analytics.

A deleted column is no longer available to any visualization, calculation, or filter that uses that dataset.
Deleted columns aren't available for table joins, whereas hidden columns are. See Hide a Column in a Dataset.
  1. On your home page, hover over a dataset that you own, click Actions Icon for Actions menu, and then select Open
    Description of open-dataset.png follows
    Description of the illustration open-dataset.png

    .
    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.
  2. In the transform editor, hover over the column that you want to hide and click Options Options ellipsis icon.in the column header.
    Description of column-options-menu.png follows
    Description of the illustration column-options-menu.png

  3. Select Delete.
    A new data transform step named Delete Column <Column name> is added to the Preparation Script. To undo, delete this step.