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 the illustration data-preparation-toggle-options.png

   
   
2. Click AI Assistant .
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. Optional: If you'd like to further enhance column names using AI Assistant, click Generate Column Names.
   
   
   Description of the illustration beautify-column-names.png
   
   
   Use this option if the metadata is cryptic and requires abbreviations to be expanded or column names to be improved. AI Assistant uses a large-language model (LLM) to obtain important metadata and metrics about each column to assist in renaming the columns to a more meaningful and easy-to-understand name for analytics consumers.
6. To accept the new column names, 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.