0 ×

Math Formula (Variable)

KNIME Math Expression Node version 3.7.0.v201811261407 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

: (Optional) input variables

Output Ports

: Input variables with the new or replaced output variable.

Best Friends (Outgoing)

Row Filter (9 %) Streamable
Math Formula (Variable) (6 %)
Merge Variables (6 %)
String Manipulation (Variable) (4 %)
CASE Switch Data (Start) (4 %)
Rule-based Row Filter (3 %) Streamable
Math Formula (3 %) Streamable
Rule Engine (2 %) Streamable
Variable Condition Loop End (2 %)
Rule Engine Variable (2 %)
String Manipulation (2 %) Streamable
Date&Time Shift (2 %) Streamable
Inject Variables (Data) (1 %)
Variable to Table Row (1 %)
CASE Switch Variable (Start) (1 %)
~~IF Switch (Flow Variable Value)~~ (1 %) Deprecated
Wait... (1 %)
Variable to Table Column (1 %) Streamable
Java Edit Variable (1 %)
Loop End (1 %)
Counting Loop Start (1 %)
k-Means (1 %)
Column to Grid (1 %)
Create Table Structure (1 %)
Partitioning (1 %)
WrappedNode Output (1 %)
Moving Aggregation (1 %)
Database Row Filter (< 1 %)
Database Table Selector (< 1 %)
Table Creator (< 1 %)
Chunk Loop Start (< 1 %)
Recursive Loop End (< 1 %)
Column Filter (< 1 %) Streamable
Row Splitter (< 1 %) Streamable
GroupBy (< 1 %)
Rule-based Row Splitter (< 1 %) Streamable
CASE Switch Variable (End) (< 1 %)
Date/Time Shift (legacy) (< 1 %)
Date/Time Shift (legacy) (< 1 %)
Flow Variable End IF (< 1 %)
Create File Name (< 1 %)
Feature Selection Loop End (< 1 %)
Interval Loop Start (< 1 %)
Generic Loop Start (< 1 %)
Group Loop Start (< 1 %)
Variable Loop End (< 1 %)
Add Empty Rows (< 1 %)
Lag Column (< 1 %) Streamable
Constant Value Column (< 1 %) Streamable
Column Rename (< 1 %) Streamable
Row Sampling (< 1 %)
IF Switch (< 1 %)
Send Email (< 1 %)
Counter Generation (< 1 %)
Java Edit Variable (simple) (< 1 %)
Text Output (< 1 %)
Generic JavaScript View (< 1 %)
Parameter Optimization Loop End (< 1 %)
Spark SQL Query (< 1 %)
Flow Variable IF Switch (< 1 %)
~~Flow Variable IF Switch (Flow Variable Value)~~ (< 1 %) Deprecated
Virtual Screening Metrics (< 1 %)
Element Selector (< 1 %)
Unzip Files (< 1 %)
Breakpoint (< 1 %)
Catch Errors (Var Ports) (< 1 %)
Try (Data Ports) (< 1 %)
Try (Variable Ports) (< 1 %)
Table Row to Variable (< 1 %)
Table Row To Variable Loop Start (< 1 %)
CSV Reader (< 1 %)
Database Reader (< 1 %)
Database SQL Executor (< 1 %)
Database Connector (< 1 %)
Table Writer (< 1 %)
Java Snippet (< 1 %) Streamable
Feature Selection Filter (< 1 %)
Column List Loop Start (< 1 %)
Recursive Loop End (2 ports) (< 1 %)
Recursive Loop Start (< 1 %)
X-Partitioner (< 1 %)
Hierarchical Cluster Assigner (< 1 %)
Logistic Regression Learner (< 1 %)
Gradient Boosted Trees Learner (< 1 %)
Auto-Binner (< 1 %)
Cell Replacer (< 1 %) Streamable
Column Rename (Regex) (< 1 %) Streamable
Numeric Row Splitter (< 1 %)
Sorter (< 1 %)
Column Splitter (< 1 %) Streamable
Create Temp Dir (< 1 %)
Spark SQL Query (< 1 %)
Microsoft SQL Server Connector (< 1 %)
Empty Table Creator (< 1 %)
Gaussian Distributed Assigner (< 1 %)
Random Number Assigner (< 1 %)
TimeDelay Loop Start (< 1 %)
Bar Chart (JavaScript) (< 1 %)
Column Expressions (< 1 %) Streamable
Math Formula (Multi Column) (< 1 %) Streamable
Line Chart (JFreeChart) (< 1 %)
Read Excel Sheet Names (XLS) (< 1 %)
Java Snippet (simple) (< 1 %)
Java IF (Table) (< 1 %)
Dict Replacer (2 In-Ports) (< 1 %) Streamable
LibSVM (3.7) (< 1 %)
Google Analytics Query (< 1 %)
Slider Input (< 1 %)
Image Features (< 1 %)
Image Cropper (< 1 %)
Rotation 2D (< 1 %)
Tile Loop Start (< 1 %)
Distance Matrix to Network (< 1 %)
Parameter Optimization Loop Start (< 1 %)
R Snippet (< 1 %)
R To R (< 1 %)
R to Table (< 1 %)
Table to R (< 1 %)
GET Request (< 1 %) Streamable
Create Date&Time Range (< 1 %)
Extract Time Window (legacy) (< 1 %)
Time Generator (legacy) (< 1 %)
Time Generator (legacy) (< 1 %)
String to Date/Time (legacy) (< 1 %) Streamable
HttpRetriever (< 1 %)
Show all 125 recommendations

Workflows

Installation

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

KNIME 3.7

Wait a sec! You want to explore and install nodes even faster? We highly recommend our NodePit for KNIME extension for your KNIME Analytics Platform.