Expression

Class: NodeDataExpression

Node Icon

Calculates new column data with a user defined expression. Expressions can contain variables from several columns, and can be output either in the original data collection or as a new single column data collection. Columns are accessed by c1, c2, c3, ..., and the row index is accessed by ri.

Inputs

In

The input data collection.

Type: DataCollection, Required, Single

Outputs

Result

The resulting data collection.

Type: DataCollection

Settings

Expression

Expression Text

The expression which should be calculated on the data columns.

Result

Output Type Selection

Overwrite results to a specific column, Append to the end, or output as New data collection.

Values: Overwrite, Append, New

Column Header Text

Header name for results column.

Set Infinity To Number

What value should Infity be set to.

Set Undefined Numbers To Number

What value should undefined numbers be set to.

Overwrite

Overwrite To Column Integer

Overwrite to specified column.

New

New Table name Text

If New is selected, this is the name of the new data collection.

See also

Keywords: