In the transform editor you can edit the Data Type, Treat As, Aggregation, Hidden, or number format properties of a dataset column. For example, you might configure a number column as currency so that you can create financial reports.

In Data view (), you configure the properties of one column at a time. In Metadata view (), you can update the properties of multiple columns at the same time. Oracle Analytics adds each property change to the Preparation Script panel. You can select to rollback changes using the Undo command.

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. To configure the properties of one column:
   1. From the toolbar, click Data ().
   2. Select a column and use the properties pane at the bottom of the Data Panel to change the properties. For example, use Number Format to configure a number column as currency.
      
      

      
      Description of the illustration configure-column-properties.png

      
      
3. To update the Data Type, Treat As, Aggregation or Hidden properties of multiple columns at the same time:
   1. From the toolbar, click Metadata ().
      Dataset columns are listed as Data Elements.
   2. Select multiple data elements to configure.
      Oracle Analytics highlights selected data elements and displays an arrow in the first data element that you selected.
      
      

      
      Description of the illustration metadata-view-multiple-items-selected.png

      
      
   3. Use the properties pane at the bottom of the Data Panel to change the properties. For example, you might set the Aggregation property of selected columns to Count.
      You can also change properties by clicking the arrow in the first data element selected and selecting a configuration value from the drop-down list.
      

      
      Description of the illustration configure-column-properties-2.png

      
      

      Note:

      You can improve performance in your data preparation by turning off Use sample data () to stop generating the sample values displayed in the "Sample Values" column. The Use sample data option is displayed at the bottom right of the Metadata View.
      

      
      Description of the illustration use-sample-data-1.png