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, hover over a dataset that you own, click Actions, and then select Open.
   If the dataset contains a single table, you'll see the transform editor. If the dataset contains multiple tables, you'll see the Join Diagram. In the Join Diagram, right-click a data source and click Open to display the transform editor.
   

   
   Description of the illustration data-preparation-toggle-options.png

   
   
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.