1. Visualizing Data in Oracle Analytics Server
  2. Visualize 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, 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 data-preparation-toggle-options.png follows
    Description of the illustration data-preparation-toggle-options.png

  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.