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:
- Open a column list popup by pressing '$'.
- 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:
- Binning functions
- Constants
- Conversion functions
- DateTime functions
- Math functions
- Operators
- Stats functions
- Text functions
- TimeSpan functions
Videos
See also: