Hub
  • Software
  • Blog
  • Forum
  • Events
  • Documentation
  • About KNIME
  • KNIME Hub
  • Nodes
  • Math Formula (Variable)
NodeNode / Manipulator

Math Formula (Variable)

Workflow Control Variables
Drag & drop
Like
Copy short link

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.

External resources

  • KNIME E-Learning Course: Creation and usage of Flow Variables in a KNIME workflow

Node details

Input ports
  1. Type: Flow Variable
    Input Variables
    (Optional) input variables
Output ports
  1. Type: Flow Variable
    Output variables
    Input variables with the new or replaced output variable.

Extension

The Math Formula (Variable) node is part of this extension:

  1. Go to item

Related workflows & nodes

  1. Go to item
    KnimeIT_10
    Justknimeit-10
    mepivnenko > Public > KnimeIT_10
  2. Go to item
    Chapter 5 / Exercise 3
    Books KNIME Advanced Luck Exercise
    +3
    This exercise is about global and local variables. Define an engine size as global variab…
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.1_20200525 > AdvancedLuck > Chapter5 > Exercises > Exercise3
  3. Go to item
    Chapter 5 / Exercise 3
    Books KNIME Advanced Luck Exercise
    +3
    This exercise is about global and local variables. Define an engine size as global variab…
    jeany > Public > KNIMEPress > KNIME_Advanced_Luck_4.3_20210222 > Chapter5 > Exercises > Exercise3
  4. Go to item
    Chapter 5 / Exercise 3
    Books KNIME Advanced Luck Exercise
    +3
    This exercise is about global and local variables. Define an engine size as global variab…
    rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.4_20210803 > AdvancedLuck > Chapter5 > Exercises > Exercise3
  5. Go to item
    Chapter 5 / Exercise 3
    Books KNIME Advanced Luck Exercise
    +3
    This exercise is about global and local variables. Define an engine size as global variab…
    rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.5_2022011 > AdvancedLuck > Chapter5 > Exercises > Exercise3
  6. Go to item
    Chapter 5 / Exercise 3
    Books KNIME Advanced Luck Exercise
    +3
    This exercise is about global and local variables. Define an engine size as global variab…
    rs1 > Public > KNIMEPress > KNIME_Advanced_Luck_4.6_20220810 > AdvancedLuck > Chapter5 > Exercises > Exercise3
  7. Go to item
    Split_Table_at_First_Occurence_of_Value
    nemad > Public > Split_Table_at_First_Occurence_of_Value
  8. Go to item
    Time Series Split
    stelfrich > Public > Time Series Split
  9. Go to item
    Loops
    kzhqtt > Public > _WA_American-Time-Use-Survey > Loops
  10. Go to item
    Lab4.4
    doctorbrunson > Lab4.4 > Lab4.4
  1. Go to item
  2. Go to item
  3. Go to item
  4. Go to item
  5. Go to item
  6. Go to item

KNIME
Open for Innovation

KNIME AG
Hardturmstrasse 66
8005 Zurich, Switzerland
  • Software
  • Getting started
  • Documentation
  • E-Learning course
  • Solutions
  • KNIME Hub
  • KNIME Forum
  • Blog
  • Events
  • Partner
  • Developers
  • KNIME Home
  • KNIME Open Source Story
  • Careers
  • Contact us
Download KNIME Analytics Platform Read more on KNIME Server
© 2022 KNIME AG. All rights reserved.
  • Trademarks
  • Imprint
  • Privacy
  • Terms & Conditions
  • Credits