1. Visualizing Data and Building Reports in Oracle Analytics Cloud
  2. Prepare Data
  3. Enrich and Transform Data
  4. Restore a Hidden or Deleted Column

Restore a Hidden or Deleted Column

In the Transform editor, you can restore any dataset columns that you hid or deleted.

If you don't see a column's Delete Step in the Preparation Script Panel, then the column might have been removed from the dataset. Use Edit Definition to confirm if the column has been removed instead of deleted. See Remove or Restore a Dataset Table's Columns.
  1. On the Home page, open a dataset or workbook.
    • Hover over the dataset, click Actions (Actions menu ellipsis icon), 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 (Actions menu ellipsis icon), 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. To restore a hidden or deleted columns, go to the Preparation Script Panel and locate the Hide Column or Delete Column step.
  3. Click Delete Step.
  4. Optional: To unhide one or more hidden columns, in the Transform editor, click Hidden columns and click Unhide All.
    Description of unhide-columns.png follows
    Description of the illustration unhide-columns.png