Transform Data

You can use column menu options to transform data. For example, you might convert text to uppercase or trim leading and trailing spaces from data. Transform your data to make it more useful and powerful for content consumers.

If you don’t apply the transformation script and close the workbook or the dataset, you lose all the data transform changes you’ve performed.

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. Mouse-over the column you want to transform.
3. Click Options (the ellipsis top-right of the data column ), and select a transformation option (for example, Bin, Rename or Convert to Text).
   
   
   Description of the illustration prepare-data-using-column-options.png
   
   
   Oracle Analytics adds a step for the transform option you selected to the Preparation Script panel.
4. 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.