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
Popular Predecessors
Merge Variables16 %- Math Formula (Variable)5 %
- Counting Loop Start3 %
- Merge Variables3 %
- Extract Table Dimension3 %
- Table Row to Variable2 %
- Variable Creator2 %
Table Row to Variable2 %- Generic Loop Start2 %
- Statistics2 %
- Rule Engine Variable1 %
- String Manipulation (Variable)1 %
- Variable Expressions1 %
- Chunk Loop Start1 %
- Group Loop Start1 %
- Active Branch Inverter1 %
- Extract Variables (Data)< 1 %
Interval Loop Start< 1 %- Column Filter< 1 %
- Double Configuration< 1 %
- Scorer< 1 %
File Reader< 1 %Scorer< 1 %- Math Formula< 1 %
- Integer Configuration< 1 %
- Integer Widget< 1 %
Numeric Scorer< 1 %- Date&Time Input (legacy)< 1 %
- Table Column to Variable< 1 %
- Recursive Loop Start< 1 %
- String to Number< 1 %
- Add Empty Rows< 1 %
Database Table Creator< 1 %Generic Loop Start< 1 %Row Filter (deprecated)< 1 %- Column Splitter< 1 %
- Empty Table Switch< 1 %
- Double Input (legacy)< 1 %
- Run Heavy Garbage Collector< 1 %
- Single Selection Widget< 1 %
- Text Output Widget (legacy)< 1 %
- Sorter< 1 %
CASE Switch Variable (Start)< 1 %- Parameter Optimization Loop Start< 1 %
Table Column to Variable< 1 %Flow Variable End IF< 1 %- CASE Switch End< 1 %
Table Row to Variable< 1 %- Moving Average< 1 %
Recursive Loop Start (2 ports)< 1 %- Table Row to Variable Loop Start< 1 %
- Joiner< 1 %
- Date&Time Difference< 1 %
- String to Date&Time< 1 %
- Java Edit Variable< 1 %
- Concatenate< 1 %
- Column Rename (Regex)< 1 %
- Constant Value Column< 1 %
Joiner< 1 %- IF Switch< 1 %
- String Input (legacy)< 1 %
- R Snippet< 1 %
- Numeric Scorer< 1 %
- Rule Engine< 1 %
- Column Selection (legacy)< 1 %
- CSV Reader< 1 %
- Cache< 1 %
- Domain Calculator< 1 %
- Create Date&Time Range< 1 %
- Loop End< 1 %
- Table Creator< 1 %
Counting Loop Start< 1 %- Column List Loop Start< 1 %
Recursive Loop End< 1 %Recursive Loop Start< 1 %- Column Resorter< 1 %
- Cross Joiner< 1 %
Row Splitter (deprecated)< 1 %- Missing Value< 1 %
- Rule-based Row Filter< 1 %
CASE Switch Data (Start)< 1 %- Java Edit Variable (simple)< 1 %
- Integer Input (legacy)< 1 %
- Slider Input (legacy)< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
- Catch Errors (Var Ports)< 1 %
Loop End< 1 %- GroupBy< 1 %
- String Manipulation< 1 %
- Column Expressions< 1 %
- Date&Time Configuration< 1 %
- Integer Slider Configuration< 1 %
- String Configuration< 1 %
- Single Selection Configuration< 1 %
- Date&Time Widget< 1 %
- Double Widget< 1 %
- Slider Widget< 1 %
- Variable to Table Row< 1 %
- Variable Condition Loop End< 1 %
- Pivot< 1 %
- CASE Switch Start< 1 %
- Excel Reader< 1 %
- Refresh Button Widget< 1 %
- Interval Loop Start< 1 %
- CSV Writer< 1 %
- Configurable IF/CASE Switch (Flow Variable Value)< 1 %
- Excel Writer< 1 %
- String to Path (Variable)< 1 %
- Cell Extractor< 1 %
- Rank< 1 %
- Try (Variable Ports)< 1 %
Table Row To Variable Loop Start< 1 %- Math Formula (Multi Column)< 1 %
Table Column to Variable< 1 %Line Reader< 1 %- Column Appender< 1 %
- Table Manipulator< 1 %
- Table Editor (JavaScript)< 1 %
- Extract Variables (Database)< 1 %
- Inject Variables (Data)< 1 %
Cell Splitter< 1 %- Cell Splitter< 1 %
- Reference Row Filter< 1 %
- Rule-based Row Splitter< 1 %
- Counter Generation< 1 %
- Column Selection Configuration< 1 %
- Date&Time to String< 1 %
Extract Date&Time Fields< 1 %- Table Reader< 1 %
- Duplicate Row Filter< 1 %
- Extract Table Spec< 1 %
Flow Variable IF Switch< 1 %Extract Context Properties< 1 %- Java Snippet< 1 %
- Loop End (Column Append)< 1 %
- Category to Number< 1 %
String To Number< 1 %- Nominal Value Row Filter< 1 %
- RowID< 1 %
- Value Counter< 1 %
- Value Selection (legacy)< 1 %
- Parameter Optimization Loop End< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Wait...< 1 %
CSV Writer< 1 %- Partitioning< 1 %
- Parallel Chunk Start< 1 %
- JSON Path< 1 %
- Wait< 1 %
- File Reader< 1 %
CASE Switch Data (End)< 1 %- Path to String (Variable)< 1 %
- Boolean Configuration< 1 %
- Image Resizer< 1 %
- Date&Time Shift< 1 %
- SDF Reader< 1 %
Table Column to Variable< 1 %Model Writer< 1 %- Simple Regression Tree Predictor< 1 %
Column Appender< 1 %- Lag Column< 1 %
Column Rename< 1 %- ROC Curve (legacy)< 1 %
- Similarity Search< 1 %
Excel Reader (XLS)< 1 %- Boolean Input (legacy)< 1 %
- Single Selection (legacy)< 1 %
- Date&Time-based Row Filter< 1 %
- Window Loop Start< 1 %
- URL to File Path (Variable)< 1 %
- Breakpoint< 1 %
Variable to Table Column< 1 %- Create File Name (legacy)< 1 %
Variable to Table Row< 1 %Database Reader< 1 %Variable Condition Loop End< 1 %- Tree Ensemble Learner (Regression)< 1 %
- Missing Value Column Filter< 1 %
- Row Sampling< 1 %
- Unpivot< 1 %
CASE Switch Variable (End)< 1 %- End IF< 1 %
- Box Plot (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- Save Workflow< 1 %
- DB Delete (Table)< 1 %
- DB Query Extractor< 1 %
- Distance Matrix Calculate< 1 %
Excel Writer (XLS)< 1 %Send to Tableau Server (Hyper)< 1 %- Stop Word Filter< 1 %
- Value Selection Configuration< 1 %
- Credentials Input (legacy)< 1 %
- File Upload (legacy)< 1 %
- Scorer (JavaScript)< 1 %
- Boolean Widget< 1 %
- Column Selection Widget< 1 %
- Python Source (legacy)< 1 %
- Python Edit Variable (legacy)< 1 %
Double Input (legacy)< 1 %- Duration to Number< 1 %
- Date&Time to legacy Date&Time< 1 %
- Moving Aggregator< 1 %
IF Switch (Flow Variable Value)< 1 %- Catch Errors (Data Ports)< 1 %
- Linear Regression Learner< 1 %
- Column Name Extractor< 1 %
- Normalizer (Apply)< 1 %
- Number Rounder< 1 %
- Table Transposer< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Rule Engine Variable (Dictionary)< 1 %
- Data Generator< 1 %
- TimeDelay Loop Start< 1 %
Excel Writer (XLS)< 1 %- Create File/Folder Variables< 1 %
- Column Filter Widget< 1 %
- String Widget< 1 %
- Container Input (Variable)< 1 %
- Parameter Optimization Loop Start (Table)< 1 %
- Date Field Extractor (legacy)< 1 %
- Fingerprint Similarity< 1 %
Regex Extractor< 1 %
Views
- This node has no views
Workflows
!Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub- (3D) Fragment library design workflowKNIME Hub
- 0_install_AI_extensionsKNIME Hub
- 00 Data GenerationKNIME Hub
- 00 Main MenuKNIME Hub
- Show all 1336 workflows
Links
- KNIME E-Learning Course: Creation and usage of Flow Variables in a KNIME workflowwww.knime.com/knime-introductory-course/chapter7/section1/creation-and-usage-of-flow-variables
- Rule Engine sum up to variablesby armingrudd on 2019-07-30forum.knime.com/p/66827
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.