Remove or Restore a Dataset Table's Columns

You can remove columns from a dataset table when the dataset doesn't need the columns, and you can restore any removed columns.

See About Removing or Restoring Dataset Columns.

When you remove or restore a column, those changes are displayed in the table's view in the Transform editor. Oracle Analytics warns you if the column you've chosen to remove is used in the Transform editor's Preparation Script pane. But Oracle Analytics won't warn you if the column you've chosen to remove is used in a workbook or visualization.

1. On the Home page, click Navigator and then click Data.
2. Click the Datasets tab.
3. Locate the dataset that you want to open, click Actions, and then click Open.
4. In the Join Diagram go to the Table Page Tabs and click the table that you want to work with.
5. In the Transform editor, click Edit Definition.
   
   
   Description of the illustration data_set_transform_edit_definition.jpg
   
   
6. (Optional) To remove columns, either click Remove All to remove all columns, or select the columns that you want to remove and click Remove Selected.
7. (Optional) To re-add columns, either click Add All to add all columns not included in the table, or select the columns that you want to add and click Add Selected.
8. Click OK.