1. Visualizing Data and Building Reports in Oracle Analytics Cloud
  2. Prepare Data
  3. Enrich and Transform Data
  4. Transform Data

Transform Data

You can use the transform editor to enhance your 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.
    • Hover over the dataset, click Actions (Actions menu ellipsis 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.
    • Hover over the workbook that contains the dataset, click Actions (Actions menu ellipsis icon), then 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 Ellipsis), and select a transformation option (for example, Bin, Rename or Convert to Text).
    Description of prepare-data-using-column-options.png follows
    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.