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.

Inputs

In

The input data collection.

Type: DataCollection, Required, Single

Outputs

Result

The resulting data collection.

Type: DataCollection

Settings

Data

Column Indices Text

Specify which columns that should be used in the expression using a comma separated list. First chosen column is designated a, second b and so on (e is reserved for the exp-function an is skipped).

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: