Hide or Delete a Column
In the Transform editor, you can hide or delete a column from the dataset. Hiding or deleting columns doesn't permanently remove them, and you can restore columns when needed.
It's important to understand that deleting a column is different than removing a column from a dataset:
- Use the Transform editor to delete a column.
- Deleting a column creates a step in the Preparation Script Panel. Remove the step to restore the deleted column.
- Use Edit Definition to remove a column.
- The Transform editor doesn't indicate which columns were removed, and removing a column doesn't add a step to the Preparation Script Panel. To confirm which columns were removed or to re-add them, go to Edit Definition.
Hidden columns are available for table joins. Deleted columns aren't available for table joins.
You can also hide columns in the dataset. Hiding a column is useful when you want to use a column to create a formula but don't need the column to display in the dataset. See Remove or Restore a Dataset Table's Columns.
- 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. - Hover over the dataset, click Actions (
- Click
