0 ×

**KNIME Math Expression Node** version **4.2.0.v202007090913** 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.*

- 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.

~~Table Row to Variable~~(11 %) Deprecated~~Table Column to Variable~~(9 %) Deprecated- Math Formula (Variable) (9 %)
~~Merge Variables~~(7 %) Deprecated- Table Row to Variable (7 %)
- Show all 157 recommendations

- 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

- 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 124 workflows

To use this node in KNIME, install KNIME Math Expression (JEP) from the following update site:

KNIME 4.2

A zipped version of the software site can be downloaded here. Read our FAQs to get instructions about how to install nodes from a zipped update site.

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.

Do you have feedback, questions, comments about NodePit, want to support this platform, or want your own nodes or workflows listed here as well? Do you think, the search results could be improved or something is missing? Then please get in touch! Alternatively, you can send us an email to mail@nodepit.com, follow @NodePit on Twitter, or chat on Gitter!

Please note that this is only about NodePit. We do not provide general support for KNIME — please use the KNIME forums instead.