Icon

Math Formula

The Math Formula node is used to create new or update existing numeric fields. It works on a row-by-row basis; this means that you can reference values in other columns within the same row but you cannot reference values in other rows (for that functionality, see the Lag Column and Column Expressions nodes).

With a large collection of functions and the ability to leverage column and flow variable values, the Math Formula node enables users to create their desired mathematical expressions.

Using the node is straightfoward. Along the left-hand side of the configuration menu are the Column and Flow Variable lists. In the center is a list of available functions and logical operators. Below is the expression pane, where you enter the expression you desire.

Finally, you may either create a new field (Append Column) or update an existing column (Replace Column). When you create a new field, the default field type is a Double. You may change this to an Integer type by selecting the box at the bottom of the menu.

Math Formula The Math Formula node is used to create new or update existing numeric fields. Itworks on a row-by-row basis; this means that you can reference values in othercolumns within the same row but you cannot reference values in other rows (for thatfunctionality, see the Lag Column and Column Expressions nodes).With a large collection of functions and the ability to leverage column and flow variablevalues, the Math Formula node enables users to create their desired mathematicalexpressions.Using the node is straightfoward. Along the left-hand side of the configuration menuare the Column and Flow Variable lists. In the center is a list of available functions andlogical operators. Below is the expression pane, where you enter the expression youdesire.Finally, you may either create a new field (Append Column) or update an existingcolumn (Replace Column). When you create a new field, the default field type is aDouble. You may change this to an Integer type by selecting the box at the bottom ofthe menu. Create the column Pop Percentage. It takes thevalue of Population2010 and divides by the COLSUM of Population2010. Night Heron Data, 2023 Update an existing column. Here, we updatedPopulation2010 by diving it by 1,000,000 androunding the result to two decimal places. Input some dataCreate a newcolumnUpdateexisting column Table Creator Math Formula Math Formula Math Formula The Math Formula node is used to create new or update existing numeric fields. Itworks on a row-by-row basis; this means that you can reference values in othercolumns within the same row but you cannot reference values in other rows (for thatfunctionality, see the Lag Column and Column Expressions nodes).With a large collection of functions and the ability to leverage column and flow variablevalues, the Math Formula node enables users to create their desired mathematicalexpressions.Using the node is straightfoward. Along the left-hand side of the configuration menuare the Column and Flow Variable lists. In the center is a list of available functions andlogical operators. Below is the expression pane, where you enter the expression youdesire.Finally, you may either create a new field (Append Column) or update an existingcolumn (Replace Column). When you create a new field, the default field type is aDouble. You may change this to an Integer type by selecting the box at the bottom ofthe menu. Create the column Pop Percentage. It takes thevalue of Population2010 and divides by the COLSUM of Population2010. Night Heron Data, 2023 Update an existing column. Here, we updatedPopulation2010 by diving it by 1,000,000 androunding the result to two decimal places. Input some dataCreate a newcolumnUpdateexisting column Table Creator Math Formula Math Formula

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: johnemery
Created at: 2023-05-19
On NodePit since: 2023-05-21
Last update: 2024-05-02
Created with KNIME version: v4.7.2
Tags: math formulanode bitesnight heron data

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!