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 .
- 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. For file-based data sources, Oracle Analytics displays the transform editor directly.
- Select the dataset, click the Actions Menu
- Select a step in the Preparation Script pane and click Edit Step.
- 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.
- In the step editor, update the fields to edit the data transform changes that are applied to the columns.
- Click OK to update the column and close the step editor.
- 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
Restoring a Hidden or Deleted Column
Creating Calculated Data Elements in a Workbook
Last Published Friday, December 8, 2023