Skip to main content

Add new column

Adds a column of the specified type to the current table, and initializes it using the specified expression ( mathematical function, constants, platform objects properties and functions).

To add new columns, you can use data from existing columns as follows:

  • To reference each row of a column, specify its name in the curly brackets, preceded by the dollar sign: ${Width}. For example you can use this expression in function like that: Round(${Width}) .

  • To reference a whole column, specify its name in the square brackets, preceded by the dollar sign: $[Width]. For example you can use this expression in function like that: Avg($[Width]).

To add a column to a formula, drag it to the editor. Alternatively, use the keyboard:

  1. Open a column list popup by pressing '$'.
  2. Select the column you want using the up and down arrows, then press Enter.

For formulas where row index is required, row variable is available.

Example:

1.57 * RoundFloat(${Weight}, 2) / Avg($[Weight]) - log(${IC50} * PI)

To treat data as strings use quotes, for example:

"Police" + "man"    // "Policeman"

The platform supports a large number of functions, constants and operators. You can find out about them in the corresponding sections of the help system:

Videos

Add New Columns

See also: