Rename Columns Using AI Assistant

You can use AI Assistant to rename columns. AI Assistant can apply optimal casing, remove underscores, and enhance column names to make it easier for users to infer the type of information contained in columns.

  1. On your 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. Click AI Assistant AI Assistant icon.
  3. Under Case, select the style that you want. For example, lower case, upper case, or title case.
  4. Under Replace, select the style that you want for underscores and spaces. For example, remove underscores or remove spaces.
  5. Click Generate Column Names.
    Description of beautify-column-names.png follows
    Description of the illustration beautify-column-names.png

  6. If required, repeat steps 3 to 5 until you're happy with the column names listed under New, then click Apply.
    Oracle Analytics adds a step named Rename Column to the Preparation Script panel.
  7. To save your data preparation changes and apply them to your data, click Save Dataset.
    The changes you make apply to all workbooks using that data source.