Restoring 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.

  1. On the Home page, open a dataset or workbook.
    • Select the dataset, click the Actions Menu 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.
    • Select the workbook that contains the dataset, click the Actions Menu icon, 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.

  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.

Related Topics

Preparing your Data Set for Analysis

About Data Enrichment and Transformation in CIC Analytics

Enriching and Transforming Your Data

Accepting Enrichment Recommendations

Transforming Data Using Column Menu Options

Transforming Data Using Replace

Converting Text Columns to Date or Time Columns

Adjusting the Display Format of a Date or Number Column

Creating a Bin Column When You Prepare Data

Configuring Column Properties in a Dataset

Hiding or Deleting a Column

Editing the Data Preparation Script

Adding Columns to a Dataset

Creating Calculated Data Elements in a Workbook



Last Published Friday, December 8, 2023