Math Formula (Variable)
KNIME Math Expression Node version 4.3.0.v202011191509 by KNIME AG, Zurich, Switzerland
This node evaluates a (free-form) mathematical expression based on the values of the flow variables. The computed results can be either appended as new variable or be used to replace an input variable. Commonly used functions are shown in the list "Mathematical Functions". There are also some constants available, such as pi (the ratio of the circumference of a circle to its diameter) and e (the base of the natural logarithms).
This node uses JEP, the Java Math Expression Parser.
You can reference the integer flow variables like this: $${IflowVar}$$,
the floating point flow variables like this: $${DflowVar}$$.
NaN values act as value true in boolean expressions and compared to anything (including NaN) in any way (including ==, but not !=, which is like !(... == ...)) is false (0).
Please note the expressions are case sensitive.
Options
- Flow Variable List
- Available flow variables, which can be used as variables in the expression.
- Category
- The operator categories.
- Function
- A list of valid operators in the selected category.
- Description
- Short help about the operator.
- Expression
- The mathematical expression editor. You have completion available.
- Append Variable
- The name of the variable to append.
- Replace Variable
- The variable to be replaced.
- Convert to Int
- The result should be converted to an integer, or kept as a floating point number.
Input Ports
Output Ports
Best Friends (Incoming)
Table Row to Variable(11 %) DeprecatedTable Column to Variable(9 %) Deprecated- Math Formula (Variable) (9 %)
Merge Variables(7 %) DeprecatedTable Row to Variable(7 %) Deprecated- Show all 157 recommendations
Best Friends (Outgoing)
- Row Filter (11 %) Streamable
- Math Formula (Variable) (7 %)
- String Manipulation (Variable) (5 %)
- Math Formula (5 %) Streamable
- Rule-based Row Filter (4 %) Streamable
- Show all 267 recommendations
Workflows
00_Guided_Labeling_for_Document_Classification_(legacy) (KNIME Hub) - 01_Accessing_Transforming_and_Modeling_Time_Series (KNIME Hub)
- 01_Accessing_Transforming_and_Modeling_Time_Series (KNIME Hub)
- 01_AutoML_Component_via_Interactive_Views (KNIME Hub)
- 01_Clickstream_Analysis (KNIME Hub)
- Show all 192 workflows
Installation
To use this node in KNIME, install KNIME Math Expression (JEP) from the following update site:
A zipped version of the software site can be downloaded here.
You don't know what to do with this link? Read our NodePit Product and Node Installation Guide that explains you in detail how to install nodes to your KNIME Analytics Platform.
Developers
You want to see the source code for this node? Click the following button and we’ll use our super-powers to find it for you.