Change Column Types using AI Assistant

When you edit a dataset in the transform editor, you can use AI Assistant to change the column type of measures and attributes. For example, if the semantic profiler initially identifies a column with numeric IDs such as 1078220 as a measure, you can change the column to an attribute.

  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. Display the Treat-As tab.
  4. Select columns to change from the type specified under Current to the type specified under New.
    Description of treat-setting.png follows
    Description of the illustration treat-setting.png

  5. Click Apply.