Hiding or Deleting 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.

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:CIC Analytics displays a Data Diagram for single-table datasets or a Join Diagram for multi-table datasets.
Hover over the column that you want to hide or delete.
Click Options, and select Hide or Delete.

Related Topics