Skip to main content

New Column

Use New Column task to add a new column of a provided type to your data. When you create a column, only the column is created and no values are filled in the column.

This is just one of the ways to create a new column. See info towards the end of this page for other ways of creating a new column with values.


Let us start with the following data


We can add a couple of new columns by doing the following

  1. Go to Transform > Column Functions.
  2. Select the New Column function.
  3. Enter a new column name, say Age. Let us choose the numeric as the data type of the new column.
  4. Click on New Column. This will add another column to the list.
  5. Enter another new column name, say Gender
  6. Click APPLY

After this task, data will look like this:


Supported Options

  1. Column Name: The name of the new column.
  2. Data type: The type of the new column.

Multiple new columns can be created using this rule.

  1. Label & Insert: For creating new column with default values.
  2. Copy Column Values: For copying values from a given column to a new Column.
  3. Math rule: For creating new columns as a calculation on other columns.