Edit the Data Preparation Script

You can edit the data transformation changes added to the Preparation Script. For example, you can edit, preview, or delete transformation steps before you apply them.

Both before and after you’ve applied recommended changes displayed in the Column Action Panel, you can edit the data transformation steps. The edit option isn't available for all types of transform steps.

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

1. 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:

   Oracle Analytics displays a Data Diagram for single-table datasets or a Join Diagram for multi-table datasets.
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 isn’t 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.