Editing the Data Preparation Script

You can edit the data transformation changes added to the Preparation Script.

Both before and after you have executed Apply Script, you can edit the data transformation steps. The edit option is not available for all types of transform steps. If you are editing the steps after executing Apply Script, you must re-apply the script to the entire data set. If you do not save the updates to a step and navigate to another step, a warning message is displayed indicating that you have not saved the changes.

The updates to the columns are applied only to the data set and not to the visualization. To ensure that you see the most up-to-date data, on the Visualize canvas, click Refresh Data icon.

  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. For file-based data sources, Oracle Analytics displays the transform editor directly.

  2. Select a step in the Preparation Script pane and click Edit Step.
  3. Select a transform step in the Preparation Script pane and click the pencil icon or Edit Transform.

    If a step is not editable, a message is displayed when you hover over the pencil icon that editing for the transform step has been disabled.

  4. In the step editor, update the fields to edit the data transform changes that are applied to the columns.
  5. Click OK to update the column and close the step editor.
  6. To save your data preparation changes and apply them to your data, click Save Dataset.

    If you're working with a single table dataset or a file-based dataset, click Apply Script.

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

Restoring a Hidden or Deleted Column

Adding Columns to a Dataset

Creating Calculated Data Elements in a Workbook



Last Published Friday, December 8, 2023