The Math Formula (Multi Column) node is an extension of the Math Formula
node which evaluates a mathematical expression based on
the values in a row for a set of selected columns. It allows the user to
do with a single node what would otherwise require multiple nodes. If
you wanted to evaluate the same expression for more than one column with the Math Formula
node, you would need to string several Math Formula nodes together. For these cases,
the Math Formula (Multi Column) allows you to write a formula that refers to
the current column in a set of selected columns.
E.g.
to add 1 to the values of columns A, B, and C, you would select columns A, B, and C
and enter the formula "$$CURRENT_COLUMN$$ + 1" into the Expression editor.
The computed results can be either appended as
new columns or be used to replace the selected input columns.
Available variables to use in the
expression are the values in the corresponding row of the table (left list
in the dialog).
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), e (the base of the natural logarithms), the total
number of rows in the table, and some other column based constants
(constant category of functions).
This node uses JEP, the Java Math Expression Parser.
Column based constants such as COL_MIN(col_name) will be calculated in advance (if necessary).
You can reference the integer flow variables like this: $${IflowVar}$$,
the floating point flow variables like this: $${DflowVar}$$.
The set of selected columns can be referenced using the CURRENT_COLUMN placeholder which looks like this:
$$CURRENT_COLUMN$$. In each iteration of the node (looping over the set of selected columns) this
placeholder will be replaced with the column name from the current iteration.
It doesn't work for columns which contain dollar signs in their name.
Reference the columns with the form: $colName$
When any of the used columns contains a missing value, the result is missing, just like when the result would be NaN, infinite value, or outside of the 32 bit signed integer range when that is requested.
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
Selected Columns
Math Expression
Popular Predecessors
- GroupBy7 %
- Joiner7 %
- Math Formula7 %
- Math Formula (Multi Column)5 %
- Column Filter5 %
- Missing Value4 %
Row Filter (deprecated)3 %- Pivot3 %
- String to Number3 %
- Rule Engine3 %
Column Rename2 %- Concatenate2 %
- Java Snippet2 %
- Rule-based Row Filter2 %
- Column Aggregator1 %
- Column Expressions1 %
- Excel Reader1 %
- Column Resorter1 %
- Sorter1 %
- String Manipulation1 %
- Rule-based Row Splitter1 %
- String Manipulation (Multi Column)1 %
Row Splitter (deprecated)< 1 %- Table Transposer< 1 %
- Constant Value Column< 1 %
- CSV Reader< 1 %
- Column Renamer< 1 %
- Column Appender< 1 %
- Column Auto Type Cast< 1 %
Scorer< 1 %Concatenate (Optional in)< 1 %- Cross Joiner< 1 %
- Table Row to Variable< 1 %
- Row Filter (Labs)< 1 %
Number To String< 1 %- DB Reader< 1 %
Table Row To Variable Loop Start< 1 %- Table Creator< 1 %
Linear Correlation< 1 %Table Column to Variable< 1 %- Duplicate Row Filter< 1 %
- Group Loop Start< 1 %
- Date&Time Difference< 1 %
- PCA Compute< 1 %
- Number to String< 1 %
- Column Splitter< 1 %
- String to Date&Time< 1 %
- Number Rounder< 1 %
- Table Manipulator< 1 %
- One to Many< 1 %
- Lag Column< 1 %
- Moving Aggregator< 1 %
- Date&Time Part Extractor< 1 %
- Chunk Loop Start< 1 %
- Loop End< 1 %
- Timer Info< 1 %
- Line Plot (Plotly)< 1 %
- Column Rename (Regex)< 1 %
Joiner< 1 %- Double Widget< 1 %
- File Reader< 1 %
- Double to Integer< 1 %
- Reference Row Splitter< 1 %
- RowID< 1 %
- String to Number (PMML)< 1 %
- DB Query Reader< 1 %
- Row to Column Names< 1 %
- Reference Row Filter< 1 %
Python Script (2⇒1)< 1 %- Normalizer< 1 %
- Table Column to Variable< 1 %
Cell Replacer< 1 %- Reference Column Resorter< 1 %
- Statistics< 1 %
- Color Manager< 1 %
- Nominal Value Row Splitter< 1 %
- IF Switch< 1 %
- PCA Apply< 1 %
File Reader< 1 %Loop End (2 ports)< 1 %- Column List Loop Start< 1 %
- X-Aggregator< 1 %
Cell Splitter< 1 %- String Manipulation (Variable)< 1 %
- Date&Time-based Row Filter< 1 %
- Cell Splitter< 1 %
Merge Variables< 1 %- Table Row to Variable Loop Start< 1 %
Variable to Table Column< 1 %Loop End< 1 %- Column Comparator< 1 %
- Extract Missing Value Cause< 1 %
- Nominal Value Row Filter< 1 %
- Row Sampling< 1 %
- Counter Generation< 1 %
- Add Empty Rows< 1 %
- Column Merger< 1 %
- Empty Table Creator< 1 %
- Integer Input (legacy)< 1 %
- Extract Duration Fields< 1 %
- Variable Creator< 1 %
- Weka Predictor (3.7)< 1 %
- Create Collection Column< 1 %
CSV Reader< 1 %Database Reader< 1 %- Loop End (Column Append)< 1 %
- Missing Value Column Filter< 1 %
- Normalizer (Apply)< 1 %
- Denormalizer< 1 %
- Numeric Scorer< 1 %
- Case Converter< 1 %
- Extract Table Dimension< 1 %
- JSON Path< 1 %
- String Splitter (Regex)< 1 %
- ROC Curve (JavaScript)< 1 %
- Breakpoint< 1 %
- Reference Column Filter< 1 %
String To Number (PMML)< 1 %- Unpivot< 1 %
- Value Counter< 1 %
- Math Formula (Variable)< 1 %
- Column Selection (legacy)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Cell Splitter By Position< 1 %
- Column Name Extractor< 1 %
- Filter Apply< 1 %
- Java Snippet (simple)< 1 %
- Duration to Number< 1 %
- Date&Time Shift< 1 %
- Table Difference Finder< 1 %
- Parameterized DB Query Reader< 1 %
- Value Lookup< 1 %
Recursive Loop Start< 1 %- SMOTE< 1 %
- Random Forest Learner< 1 %
- Auto-Binner< 1 %
- Category to Number< 1 %
Column Appender< 1 %- String Replacer< 1 %
Rank Correlation< 1 %- Numeric Outliers< 1 %
- Data Generator< 1 %
Read Excel Sheet Names (XLS)< 1 %- Boolean Input (legacy)< 1 %
- Date&Time to String< 1 %
- Time Difference (legacy)< 1 %
- RDKit Substructure Counter< 1 %
- Low Variance Filter< 1 %
- Rank< 1 %
- Top k Row Filter< 1 %
- Rule Engine (Dictionary)< 1 %
- Data Explorer< 1 %
Excel Reader (XLS)< 1 %- Value Filter (legacy)< 1 %
- Window Loop Start< 1 %
- Variable to Table Row< 1 %
- Rank Correlation< 1 %
- DB Writer< 1 %
- Nominal Row Filter Widget< 1 %
- CSV Writer< 1 %
- Hierarchical Clustering< 1 %
- Split Collection Column< 1 %
Table Row to Variable< 1 %Counting Loop Start< 1 %- k-Means< 1 %
- Regression Predictor< 1 %
- Numeric Binner< 1 %
- Column Combiner< 1 %
String To Number< 1 %- Column Renamer (Dictionary)< 1 %
- Reference Column Splitter< 1 %
- Constant Value Column Filter< 1 %
- Partitioning< 1 %
- Missing Value (Apply)< 1 %
- Numeric Row Splitter< 1 %
- End IF< 1 %
CASE Switch Data (Start)< 1 %- SDF Reader< 1 %
- Similarity Search< 1 %
- IDF< 1 %
- Column Filter (legacy)< 1 %
- Table View (JavaScript)< 1 %
- Python Source (legacy)< 1 %
- R Snippet< 1 %
Extract Date&Time Fields< 1 %- Moving Average< 1 %
- XPath< 1 %
- Molecular Properties< 1 %
- RDKit Fingerprint< 1 %
- Shapefile Polygon Reader< 1 %
- R Snippet< 1 %
- Inject Variables (Data)< 1 %
Table Row to Variable< 1 %- Linear Correlation< 1 %
- Domain Calculator< 1 %
- Ungroup< 1 %
- Cache< 1 %
- Merge Variables< 1 %
- Random Number Assigner< 1 %
- One Row to Many< 1 %
- Double Configuration< 1 %
- Integer Configuration< 1 %
- Multiple Selection Widget< 1 %
- JSON to Table< 1 %
- Parameter Optimization Loop End< 1 %
- R Source (Table)< 1 %
- Modify Time< 1 %
- XGBoost Predictor (Regression)< 1 %
- RDKit Descriptor Calculation< 1 %
- Variable to Table Column< 1 %
- Table Reader< 1 %
- Counting Loop Start< 1 %
- Recursive Loop Start< 1 %
- Variable Loop End< 1 %
- Scorer< 1 %
- Row Splitter (Labs)< 1 %
- Random Number Assigner (Apache)< 1 %
- Quasirandom Sequence Generator (Apache)< 1 %
- Variable Expressions< 1 %
- Line Plot (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Container Output (Table)< 1 %
- Python Script (legacy)< 1 %
- Anonymization< 1 %
- Row Aggregator< 1 %
- Cell Extractor< 1 %
- SHAP Loop End< 1 %
- Interactive Table (legacy)< 1 %
- Renderer to Image< 1 %
- Extract Variables (Data)< 1 %
Recursive Loop End (2 ports)< 1 %PCA Compute< 1 %- Distance Matrix Pair Extractor< 1 %
- Decision Tree to Ruleset< 1 %
- H2O to Table< 1 %
Excel Reader (XLS)< 1 %- Frequency Domain Features (FDF)< 1 %
Recursive Loop Start (2 ports)< 1 %Numeric Scorer< 1 %- Random Forest Predictor (Regression)< 1 %
- Equal Size Sampling< 1 %
- Rule Engine Variable< 1 %
- Gaussian Distributed Assigner< 1 %
- Image Viewer< 1 %
- Date/Time Shift (legacy)< 1 %
- Number Formatter< 1 %
- SVM Predictor< 1 %
- Random Forest Learner (Regression)< 1 %
Regex Extractor< 1 %- Gradient Boosted Trees Predictor (Regression)< 1 %
- Category to Number (Apply)< 1 %
- Empty Table Switch< 1 %
- Double Input (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- Collection Size< 1 %
- pKa< 1 %
- ARIMA Predictor< 1 %
Table Column to Variable< 1 %- Decision Tree Predictor< 1 %
- Document Vector< 1 %
- Container Input (Table)< 1 %
- Legacy Date&Time to Date&Time< 1 %
- CSV Array Reader< 1 %
- File Reader (Complex Format)< 1 %
- PCA Inversion< 1 %
- Stresser< 1 %
- String Matcher< 1 %
- Column Selection Widget< 1 %
Loop End (3 ports)< 1 %- Logistic Regression Learner< 1 %
CASE Switch Data (End)< 1 %- TF< 1 %
- MolConverter< 1 %
- Catch Errors (Data Ports)< 1 %
Variable to Table Row< 1 %List Files< 1 %Interval Loop Start< 1 %- X-Partitioner< 1 %
- PNN Predictor< 1 %
- Logistic Regression Predictor< 1 %
Gradient Boosted Trees Predictor< 1 %- Create Bit Vector< 1 %
- Column to Grid< 1 %
- Denormalizer (PMML)< 1 %
- Ruleset Editor< 1 %
- Extract Table Spec< 1 %
- DB Insert< 1 %
- Time Series Generator< 1 %
- K Nearest Neighbor (Distance Function)< 1 %
- DL4J Feedforward Predictor (Classification) (legacy)< 1 %
- Java Edit Variable (simple)< 1 %
- Column Filter Configuration< 1 %
- Scorer (JavaScript)< 1 %
- Add...< 1 %
- Parameter Optimization Loop Start< 1 %
- Create Date&Time Range< 1 %
- Modify Date< 1 %
- Mask Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- Twitter Search< 1 %
- RDKit Interactive Table< 1 %
- Substructure Match Counter< 1 %
- Random Matcher< 1 %
- PMML Ensemble Predictor< 1 %
- Term to String< 1 %
- Container Input (Variable)< 1 %
- Data Row to Image< 1 %
- Window Slider< 1 %
- Normalize Plates (POC)< 1 %
Variable to Table Row< 1 %Database Connection Table Reader< 1 %Table Reader< 1 %- Cluster Assigner< 1 %
- Fuzzy c-Means< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Table Validator (Reference)< 1 %
- HiLite Row Splitter< 1 %
String Replace (Dictionary)< 1 %- Crosstab< 1 %
- Spark to Table< 1 %
- Molecule Type Cast< 1 %
H2O Generalized Linear Model Learner (Regression)< 1 %- Java Snippet Row Filter< 1 %
- Term Co-Occurrence Counter< 1 %
- String Input (legacy)< 1 %
- Image Properties< 1 %
Python Script (1⇒1)< 1 %- R Predictor< 1 %
- R to Table< 1 %
- Coordinate to Latitude/Longitude< 1 %
Extract Outer/InnerHTML< 1 %Read MDB< 1 %- Molecule Properties< 1 %
- TIBCO Spotfire File Reader< 1 %
- Fingerprint AND< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
- Example Data< 1 %
- Split Columns by Header< 1 %
- Binning Calculate< 1 %
- Dose Response (R)< 1 %
- Outlier Removal< 1 %
- Z-Primes (PC x NC)< 1 %
- TSNE< 1 %
- Active Learning Loop Start< 1 %
- URL to File Path< 1 %
- Try (Data Ports)< 1 %
Variable to Table Column< 1 %- Create File Name (legacy)< 1 %
- Image to Table< 1 %
Parameterized Database Query< 1 %- Java Edit Variable< 1 %
Variable Condition Loop End< 1 %Generic Loop Start< 1 %Recursive Loop End< 1 %- Naive Bayes Predictor< 1 %
- Hierarchical Cluster Assigner (local)< 1 %
PCA Apply< 1 %- Linear Regression Learner< 1 %
Tree Ensemble Learner< 1 %- Tree Ensemble Learner< 1 %
- Random Forest Predictor< 1 %
- Simple Regression Tree Predictor< 1 %
- Expand Bit Vector< 1 %
- Number to Category (Apply)< 1 %
- Many to One< 1 %
- Correlation Filter< 1 %
- Create Table Structure< 1 %
- Table Validator< 1 %
- Edit Numeric Domain< 1 %
- Interactive HiLite Collector< 1 %
- One to Many (PMML)< 1 %
- Normalizer (PMML)< 1 %
- Number to String (PMML)< 1 %
- HiLite Table (legacy)< 1 %
- Parallel Chunk Start< 1 %
- Distance Matrix Calculate< 1 %
- Keras Network Executor< 1 %
- TensorFlow Network Executor< 1 %
- OpenBabel< 1 %
- DL4J Feedforward Predictor (Regression) (legacy)< 1 %
- H2O MOJO Predictor (Regression)< 1 %
- Association Rule Learner (Borgelt)< 1 %
- Geo-Coordinate Row Filter< 1 %
- ICF< 1 %
- Replacer< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- Google Sheets Reader< 1 %
- String Configuration< 1 %
Column Filter Widget< 1 %- Integer Widget< 1 %
- Table to JSON< 1 %
- Container Input (JSON)< 1 %
- Image to DataRow< 1 %
- Log...< 1 %
Python Script (2⇒2)< 1 %- Date&Time to legacy Date&Time< 1 %
- String to Date/Time (legacy)< 1 %
- XGBoost Predictor< 1 %
- Remove Empty Rows< 1 %
- Sum Formula< 1 %
- RDKit Canon SMILES< 1 %
- Trim Table< 1 %
- Copy/Move Files (legacy)< 1 %
- PCA< 1 %
- Gradient Boosted Trees Predictor< 1 %
- Expand Byte Vector< 1 %
- Filter Apply Row Splitter< 1 %
- Subset Matcher< 1 %
- Target Shuffling< 1 %
- Ruleset to Table< 1 %
- CASE Switch Start< 1 %
Color Appender< 1 %- Extract Color< 1 %
- Parquet Reader< 1 %
- DB Query Extractor< 1 %
- Gamma Distributed Assigner< 1 %
- Visual 2D Data Generator< 1 %
- Java IF (Table)< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Document Data Extractor< 1 %
- Term Neighborhood Extractor< 1 %
- Delete Files/Folders< 1 %
- List Files/Folders< 1 %
- Path to String (Variable)< 1 %
- String to Path< 1 %
- CSS Editor< 1 %
- Tag Cloud (JavaScript)< 1 %
- JSON Column Combiner< 1 %
- Container Input (Credentials)< 1 %
- Time Field Extractor (legacy)< 1 %
- BERT Predictor< 1 %
- String Similarity< 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 Send Reporting_vMediumKNIME Hub
- Show all 842 workflows
Links
- How to use if expressions in a column expressions nodeby izaychik63 on 2019-03-19forum.knime.com/p/56758
- Integer to Double Using Mathby armingrudd on 2019-04-27forum.knime.com/p/59522
- How do i average a column to become one number onlyby armingrudd on 2020-08-02forum.knime.com/p/98698
- Multiple 1 column to multiple columnby armingrudd on 2020-01-07forum.knime.com/p/78160
- How to apply the math node to a set of columnsby izaychik63 on 2020-04-20forum.knime.com/p/88228
- Show all 10 links
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.