Adding Columns in Data Preparation

You can create new columns to enhance your data.

  1. Open a project or data set.
    If you're working with a project, go to the Prepare canvas and click the data set you want to edit.
  2. In the Preparation Script pane, click Add Preparation Step.
    Alternatively, to create a column similar to an existing column, click Options on the column, and click Create.
  3. Use the Create Column pane to specify the column details.
    Use the function picker to use operators and mathematical functions in your column. For example, you might specify COLUMN1+COLUMN2 to calculate the sum of values in COLUMN1 and COLUMN2.
  4. Click Add Step.