This node evaluates a mathematical expression based on
the values in a row. The computed results can be either appended as
new column or be used to replace an input column. Available variables
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}$$.
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
Popular Successors
- Math Formula12 %
- Joiner7 %
- GroupBy7 %
- Rule Engine6 %
- Column Filter5 %
Row Filter (deprecated)5 %- Excel Writer4 %
- Concatenate4 %
- Rule-based Row Filter3 %
- Column Resorter2 %
- String Manipulation2 %
- Sorter2 %
- Number to String1 %
- Constant Value Column1 %
- Pivot1 %
- Missing Value1 %
- Number Rounder1 %
- Loop End1 %
- Column Expressions (legacy)1 %
- Rule-based Row Splitter1 %
- CSV Writer< 1 %
Row Splitter (deprecated)< 1 %- Math Formula (Multi Column)< 1 %
- Table Manipulator< 1 %
- Duplicate Row Filter< 1 %
- Normalizer< 1 %
- Column Renamer< 1 %
- Date&Time Part Extractor< 1 %
- String to Number< 1 %
- Cross Joiner< 1 %
- Group Loop Start< 1 %
- String to Date&Time< 1 %
- Numeric Binner< 1 %
- Statistics< 1 %
- Partitioning< 1 %
- Rank< 1 %
- Reference Row Filter< 1 %
- Date&Time Difference< 1 %
- Nominal Value Row Filter< 1 %
- Column Appender< 1 %
- Date&Time Shift< 1 %
- DB Writer< 1 %
- Cell Splitter< 1 %
- Column Aggregator< 1 %
- Auto-Binner< 1 %
- RowID< 1 %
- Table Transposer< 1 %
Cell Replacer< 1 %- Unpivot< 1 %
- Column Splitter< 1 %
- Java Snippet< 1 %
- Column Combiner< 1 %
- Date&Time-based Row Filter< 1 %
- Linear Regression Learner< 1 %
- k-Means< 1 %
- Lag Column< 1 %
- Table Row to Variable< 1 %
- Value Counter< 1 %
Joiner< 1 %- String Manipulation (Multi Column)< 1 %
- End IF< 1 %
- Numeric Scorer< 1 %
- Document Vector< 1 %
- Numeric Outliers< 1 %
- Color Manager< 1 %
- Column Rename (Regex)< 1 %
- Interactive Table (legacy)< 1 %
- Recursive Loop End< 1 %
- Histogram< 1 %
- Column Merger< 1 %
- Bar Chart< 1 %
- Top k Row Filter< 1 %
- Table Writer< 1 %
- Date&Time to String< 1 %
- Linear Correlation< 1 %
- Bar Chart (JFreeChart)< 1 %
- Statistics View< 1 %
- Scatter Plot< 1 %
- Row Sampling< 1 %
- Table Row to Variable Loop Start< 1 %
- Regression Predictor< 1 %
- String Replacer< 1 %
- Value Lookup< 1 %
- DB Insert< 1 %
- Java Snippet (simple)< 1 %
- Column Auto Type Cast< 1 %
- Loop End (Column Append)< 1 %
PCA< 1 %Double To Int< 1 %- Nominal Value Row Splitter< 1 %
- Row Aggregator< 1 %
- Double to Integer< 1 %
- Python Script (legacy)< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Chunk Loop Start< 1 %
- Pie Chart< 1 %
- Moving Average< 1 %
- Numeric Row Splitter< 1 %
- Data Explorer< 1 %
- IF Switch< 1 %
- String Manipulation (Variable)< 1 %
- Table View< 1 %
- Frequency Filter< 1 %
- Google Sheets Updater< 1 %
- Column Renamer (Dictionary)< 1 %
- DB Table Creator< 1 %
- One Row to Many< 1 %
- Scatter Plot (JavaScript)< 1 %
- Shapiro-Wilk Test< 1 %
- Line Plot (JavaScript)< 1 %
- Histogram (JavaScript)< 1 %
- String Splitter (Regex)< 1 %
Table to PDF< 1 %- Scatter Plot Matrix< 1 %
- Line Plot (Plotly)< 1 %
- Sunburst Chart (JavaScript)< 1 %
- Tableau Writer< 1 %
- Column Filter (legacy)< 1 %
- Column List Loop Start< 1 %
Variable Loop End< 1 %- Scorer< 1 %
Random Forest Learner< 1 %- Reference Row Splitter< 1 %
- Bar Chart (JavaScript)< 1 %
- Send to Power BI< 1 %
- JSON Path< 1 %
Python Plot< 1 %- Missing Value Column Filter< 1 %
- Scatter Plot (legacy)< 1 %
- Document Viewer< 1 %
- Moving Aggregator< 1 %
- Capture Workflow End< 1 %
- SDF Writer< 1 %
- DB Update< 1 %
- Line Chart (JFreeChart)< 1 %
- Configurable End IF/CASE< 1 %
Recursive Loop End (2 ports)< 1 %- Ungroup< 1 %
- Rank Correlation< 1 %
- CASE Switch End< 1 %
- Recursive Loop Start< 1 %
- Column Name Extractor< 1 %
- One to Many< 1 %
- Box Plot< 1 %
- Counter Generation< 1 %
- Normalizer (Apply)< 1 %
- Line Plot< 1 %
- Numeric Distances< 1 %
- Send to Tableau Server< 1 %
- Modify Time< 1 %
- Write To Excel Template (deprecated)< 1 %
- SMOTE< 1 %
- Table Validator (Reference)< 1 %
- Molecule Type Cast< 1 %
DB Table Creator< 1 %- Text Output Widget (legacy)< 1 %
- R Predictor< 1 %
- Column Comparator< 1 %
- Lift Chart (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Bubble Chart (Plotly)< 1 %
Excel Sheet Appender (XLS)< 1 %- Table to JSON< 1 %
- Data to Report (BIRT)< 1 %
- R Snippet (2:1)< 1 %
- Catch Errors (Var Ports)< 1 %
- Binner (Dictionary)< 1 %
- Number to Category (Apply)< 1 %
- Row Splitter (Labs)< 1 %
- Random Label Assigner< 1 %
- Association Rule Learner (Borgelt)< 1 %
Excel Writer (XLS)< 1 %- Tile View (JavaScript)< 1 %
- R Snippet< 1 %
- RDKit Substructure Counter< 1 %
- Dose Response (R)< 1 %
- Interval Loop Start< 1 %
- X-Partitioner< 1 %
PCA Apply< 1 %- Tree Ensemble Predictor (Regression)< 1 %
- Cell Splitter By Position< 1 %
- Row Filter (Labs)< 1 %
- Denormalizer< 1 %
- Numeric Binner (PMML)< 1 %
- Line Plot (legacy)< 1 %
- Density Plot< 1 %
- Weka Predictor (3.7)< 1 %
- Value Selection (legacy)< 1 %
- Parameter Optimization Loop End< 1 %
- Add Table to R< 1 %
- R Learner< 1 %
- Date Field Extractor (legacy)< 1 %
- RDKit Find Murcko Scaffolds< 1 %
- 2D/3D Scatterplot< 1 %
Table Column to Variable< 1 %- Table Column to Variable< 1 %
Database Looping< 1 %- Feature Selection Loop Start (1:1)< 1 %
- Category to Number< 1 %
- Constant Value Column Filter< 1 %
- Filter Apply< 1 %
Column Rename< 1 %- Rule-based Row Filter (Dictionary)< 1 %
- Scatter Plot (Plotly)< 1 %
- OpenBabel< 1 %
Excel Writer (XLS)< 1 %Send to Power BI< 1 %Send to Tableau Server (TDE)< 1 %- Topic Extractor (Parallel LDA)< 1 %
- Column Filter Configuration< 1 %
- Value Filter (legacy)< 1 %
- Interactive Value Filter Widget< 1 %
- Multiobjective Subset Selection (NSGA-II)< 1 %
- RDKit From Molecule< 1 %
Location Extractor< 1 %- Create Well Position< 1 %
- MarvinView< 1 %
Element Selector< 1 %- Split Collection Column< 1 %
- MultiLayerPerceptron Predictor< 1 %
- PCA Compute< 1 %
- Case Converter< 1 %
- Domain Calculator< 1 %
- Independent groups t-test< 1 %
- Parquet Writer< 1 %
- Table to H2O< 1 %
- Java Edit Variable (simple)< 1 %
- Table View (JavaScript)< 1 %
- Table Editor (JavaScript)< 1 %
- Shapley Values Loop Start< 1 %
Python Script (2⇒1)< 1 %- R View (Table)< 1 %
Regex Extractor< 1 %IF Switch (Flow Variable Value)< 1 %Parameterized Database Query< 1 %Loop End< 1 %- Variable Condition Loop End< 1 %
Naive Bayes Learner< 1 %- Fuzzy Rule Learner< 1 %
- DBSCAN< 1 %
- Decision Tree Predictor< 1 %
K Nearest Neighbor< 1 %- Logistic Regression Predictor< 1 %
- PCA< 1 %
- Add Empty Rows< 1 %
Cell Splitter< 1 %- Number to String (PMML)< 1 %
- Set Operator< 1 %
CASE Switch Data (Start)< 1 %- Enrichment Plotter (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
- DB Loader< 1 %
- Gamma Distributed Assigner< 1 %
- Similarity Search< 1 %
- External Tool< 1 %
R Snippet< 1 %- Google Sheets Writer< 1 %
- Feature Inserter< 1 %
- Duration to String< 1 %
- Modify Date< 1 %
- Table to HTML String< 1 %
- Window Slider< 1 %
Expand Well Position< 1 %- Python Plot< 1 %
- ARIMA Learner< 1 %
- Download / Upload from List (legacy)< 1 %
- Wait...< 1 %
Table Column to Variable< 1 %Table Row to Variable< 1 %Database Connector< 1 %Interval Loop Start< 1 %Generic Loop Start< 1 %- Entropy Scorer< 1 %
- PCA Apply< 1 %
Gradient Boosted Trees Learner< 1 %- Category to Number (Apply)< 1 %
- Table Validator< 1 %
Missing Value< 1 %String To Number (PMML)< 1 %- Table Difference Finder< 1 %
- One-way ANOVA< 1 %
- Wilcoxon-Mann-Whitney Test< 1 %
- Empty Table Switch< 1 %
- DB Table Remover< 1 %
- Stacked Area Chart (JavaScript)< 1 %
- Geo-Coordinate Row Filter< 1 %
- Tag Filter< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- Rowset Filter< 1 %
Python Script (1⇒2)< 1 %- String to Date/Time (legacy)< 1 %
- RDKit Descriptor Calculation< 1 %
- RDKit Substructure Filter< 1 %
- TIBCO Spotfire File Writer< 1 %
- Speedy SMILES De-salt< 1 %
Loop End (3 ports)< 1 %- Normalize Plates (Z-Score)< 1 %
- R Snippet< 1 %
- String to URI< 1 %
- Variable to Table Column< 1 %
- Extract Variables (Data)< 1 %
- Variable to Table Row< 1 %
- Table to Image< 1 %
Database Delete< 1 %- Image Writer (Table)< 1 %
Table Reader< 1 %- Java Edit Variable< 1 %
Backward Feature Elimination Start (1:1)< 1 %Loop End (2 ports)< 1 %Recursive Loop End< 1 %Recursive Loop Start< 1 %- MDS (DistMatrix)< 1 %
- SVM Learner< 1 %
- Create Bit Vector< 1 %
- CAIM Binner< 1 %
- Subset Matcher< 1 %
String Replace (Dictionary)< 1 %- Rule Engine (Dictionary)< 1 %
- Linear Discriminant Analysis< 1 %
- Box Plot (legacy)< 1 %
- Shape Manager< 1 %
- Save Workflow< 1 %
- Stacked Area Chart< 1 %
- Workflow Executor< 1 %
- Random Label Assigner (Data)< 1 %
- Keras Network Learner< 1 %
- 2D Density Plot (Plotly)< 1 %
- H2O MOJO Predictor (Regression)< 1 %
- Interval Chart (JFreeChart)< 1 %
XLS Writer< 1 %- Excel Cell Updater< 1 %
- Java Snippet Row Filter< 1 %
- Radar Plot Appender< 1 %
- Workflow Data Area Connector< 1 %
- Value Selection Widget< 1 %
- Binary Classification Inspector< 1 %
- Table to R< 1 %
- Table Difference Checker< 1 %
- Fingerprints< 1 %
- RDKit MCS< 1 %
- RDKit Molecule Substructure Filter< 1 %
- RDKit Fingerprint< 1 %
- Wait< 1 %
- Fast Fourier Transform (FFT)< 1 %
- Time Domain Features (TDF)< 1 %
- XLS Control Table Generator< 1 %
- Notched Boxplot (JFreechart)< 1 %
- Collection to String< 1 %
- Number Formatter< 1 %
- Range Filter< 1 %
- Normalize Plates (NPI)< 1 %
- Plate Heatmap Viewer< 1 %
- R Plot< 1 %
- Aqueous Solubility< 1 %
- Standardizer< 1 %
- Fingerprint Similarity< 1 %
- Pareto Ranking< 1 %
- Free-Wilson Matched Pairs< 1 %
- ARIMA Visualization< 1 %
- Breakpoint< 1 %
Database Writer< 1 %Table Writer< 1 %- Variable Loop End< 1 %
- Fuzzy c-Means< 1 %
- Hierarchical Clustering< 1 %
- K Nearest Neighbor< 1 %
- Polynomial Regression Learner< 1 %
Scorer< 1 %- Association Rule Learner< 1 %
Gradient Boosted Trees Predictor< 1 %- Gradient Boosted Trees Predictor< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
- Random Forest Predictor< 1 %
- Auto-Binner (Apply)< 1 %
Number To String< 1 %Column Appender< 1 %- Column to Grid< 1 %
- Correlation Filter< 1 %
- Edit Numeric Domain< 1 %
Column Filter< 1 %- HiLite Row Splitter< 1 %
- Low Variance Filter< 1 %
- Missing Value (Apply)< 1 %
- Normalizer Apply (PMML)< 1 %
- String to Number (PMML)< 1 %
- Reference Column Resorter< 1 %
- Cell Extractor< 1 %
- Table Splitter< 1 %
- Rule Engine Variable< 1 %
- Kruskal-Wallis Test< 1 %
- Paired t-test< 1 %
- Cache< 1 %
- Merge Variables< 1 %
- HiLite Table (legacy)< 1 %
- Size Manager< 1 %
- Heatmap< 1 %
Parquet Writer< 1 %- DB Merge< 1 %
- Parameterized DB Query Reader< 1 %
- Beta Distributed Assigner< 1 %
- Random Number Assigner< 1 %
- 3D Scatter Plot (Plotly)< 1 %
- Box Plot (JavaScript)< 1 %
- Generic Web Service Client< 1 %
- Math Formula (Variable)< 1 %
- HeatMap (JFreeChart)< 1 %
- Scatter Plot (JFreeChart)< 1 %
- Table Indexer< 1 %
- OSM Map View< 1 %
- Term Co-Occurrence Counter< 1 %
- TF< 1 %
- Chi-Square Keyword Extractor< 1 %
- Number Filter< 1 %
- String to Term< 1 %
- Tag Cloud< 1 %
- Google Sheets Appender< 1 %
- JPMML Classifier< 1 %
- Column Selection Configuration< 1 %
- Column Selection (legacy)< 1 %
- Heatmap (JavaScript)< 1 %
- Container Output (Table)< 1 %
- Global Thresholder< 1 %
Python View< 1 %- Python View (legacy)< 1 %
- Duration to Number< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Byte Converter< 1 %
- XPath< 1 %
- Row Splitter (col+)< 1 %
- RDKit Canon SMILES< 1 %
- Regex Extractor< 1 %
- Frame< 1 %
- XLS Font Formatter< 1 %
- Multiport Loop End< 1 %
- Benchmark End< 1 %
- 1D Kernel Density Plot< 1 %
- Join Layout< 1 %
- Create Interval< 1 %
- Normalize Plates (POC)< 1 %
- Outlier Removal< 1 %
CV< 1 %- Major Microspecies< 1 %
- MolConverter< 1 %
- Table To Excel Cell Updater< 1 %
- Desirability Ranking< 1 %
- Automated Matched Pairs< 1 %
- Create Collection Column< 1 %
- Binary Objects to Strings< 1 %
- Catch Errors (Data Ports)< 1 %
- Try (Data Ports)< 1 %
- Active Branch Inverter< 1 %
Variable to Table Column< 1 %- Create File Name (legacy)< 1 %
- Inject Variables (Data)< 1 %
Table Row to Variable< 1 %Table Row To Variable Loop Start< 1 %Image Writer (Table Column)< 1 %- ARFF Writer< 1 %
CSV Writer< 1 %- CSV Reader< 1 %
- Table Creator< 1 %
- Variable Creator< 1 %
- Feature Selection Filter< 1 %
- Feature Selection Loop End< 1 %
- Counting Loop Start< 1 %
Counting Loop Start< 1 %Variable Condition Loop End< 1 %- Generic Loop Start< 1 %
- X-Aggregator< 1 %
- Naive Bayes Predictor< 1 %
- PNN Learner (DDA)< 1 %
- Cluster Assigner< 1 %
- Decision Tree Learner< 1 %
- RProp MLP Learner< 1 %
PCA Compute< 1 %- Logistic Regression Learner< 1 %
- SOTA Predictor< 1 %
Simple Regression Tree Learner< 1 %- Gradient Boosted Trees Learner< 1 %
- Gradient Boosted Trees Learner (Regression)< 1 %
- Tree Ensemble Learner (Regression)< 1 %
- Random Forest Learner< 1 %
- Random Forest Learner (Regression)< 1 %
- Random Forest Predictor (Regression)< 1 %
- Simple Regression Tree Learner< 1 %
- Simple Regression Tree Predictor< 1 %
Concatenate (Optional in)< 1 %- Bootstrap Sampling< 1 %
- Many to One< 1 %
- Equal Size Sampling< 1 %
- Extract Missing Value Cause< 1 %
- Reference Column Filter< 1 %
- Reference Column Splitter< 1 %
- Filter Apply Row Splitter< 1 %
- Column Filter (PMML)< 1 %
- Normalizer (PMML)< 1 %
- Row to Column Names< 1 %
- Shuffle< 1 %
- String Replacer (Dictionary)< 1 %
- Table Cropper< 1 %
- Ruleset Editor< 1 %
Rank Correlation< 1 %- Proportion Test< 1 %
- Single sample t-test< 1 %
- CASE Switch Start< 1 %
CASE Switch Data (End)< 1 %- Extract Table Dimension< 1 %
- Extract Table Spec< 1 %
- Send Email< 1 %
- Timer Info< 1 %
- Conditional Box Plot (legacy)< 1 %
- Crosstab< 1 %
- Number Format Manager< 1 %
- Histogram (legacy)< 1 %
- Interactive Pie chart (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
Color Appender< 1 %- Shape Appender< 1 %
- ROC Curve (legacy)< 1 %
- ORC Writer< 1 %
- Table to Spark< 1 %
- Parallel Chunk End< 1 %
- Microsoft SQL Server Connector< 1 %
- DB Connector< 1 %
- DB Connection Closer< 1 %
- DB Delete (Table)< 1 %
- DB SQL Executor< 1 %
- Conditional Label Assigner< 1 %
- Empty Table Creator< 1 %
- Gaussian Distributed Assigner< 1 %
- Random Item Inserter< 1 %
- Time Series Generator< 1 %
- Mahalanobis Distance< 1 %
- Distance Matrix Calculate< 1 %
- k-Medoids< 1 %
- K Nearest Neighbor (Distance Function)< 1 %
- Conditional Box Plot (JavaScript)< 1 %
- Pie/Donut Chart (JavaScript)< 1 %
- Violin Plot (Plotly)< 1 %
- Model Loop Start< 1 %
- PMML Predictor< 1 %
- Table to PDF (legacy)< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Pie Chart (JFreeChart)< 1 %
- Bubble Chart (JFreeChart)< 1 %
- LIBSVMPredictor< 1 %
Microsoft Authenticator (Deprecated)< 1 %Excel Sheet Appender (XLS)< 1 %- Excel Reader< 1 %
- Java IF (Table)< 1 %
- Java Snippet Row Splitter< 1 %
- Spark Line Appender< 1 %
- NGram Creator< 1 %
- Punctuation Erasure< 1 %
- Document Data Extractor< 1 %
- Document Vector Applier< 1 %
- Document Vector Hashing< 1 %
- Strings to Document< 1 %
- Tags to String< 1 %
- Term to String< 1 %
- Path to String< 1 %
- String to Path< 1 %
- String to Path (Variable)< 1 %
Google Authenticator (API Key)< 1 %- Nominal Row Filter Configuration< 1 %
- Date&Time Configuration< 1 %
- Double Configuration< 1 %
- Value Selection Configuration< 1 %
- Text Output (legacy)< 1 %
- Scorer (JavaScript)< 1 %
- Decision Tree View (JavaScript)< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Lift Chart (JavaScript)< 1 %
- ROC Curve (JavaScript)< 1 %
- Tag Cloud (JavaScript)< 1 %
- Column Filter Widget< 1 %
- Interactive Range Slider Filter Widget< 1 %
- Nominal Row Filter Widget< 1 %
- Slider Widget< 1 %
- Column Selection Widget< 1 %
- Container Output (Row)< 1 %
- JSON Transformer< 1 %
- Columns to JSON< 1 %
- Gaussian Convolution< 1 %
- Don't Save Start< 1 %
- Multi Feature Inserter< 1 %
- Object Inserter< 1 %
Python Script (1⇒1)< 1 %- Python Edit Variable (legacy)< 1 %
- GET Request< 1 %
- POST Request< 1 %
- Date&Time to legacy Date&Time< 1 %
- String to Duration< 1 %
- Create Date&Time Range< 1 %
Extract Date&Time Fields< 1 %- Extract Duration Fields< 1 %
- Modify Time Zone< 1 %
- Window Loop Start< 1 %
- Date/Time Shift (legacy)< 1 %
- Time Difference (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
- Time Generator (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- Time to String (legacy)< 1 %
- Workflow Service Output< 1 %
- XGBoost Tree Ensemble Learner< 1 %
- XGBoost Predictor< 1 %
- XGBoost Predictor (Regression)< 1 %
- Column to XML< 1 %
- XML Writer< 1 %
- Molecule to CDK< 1 %
- Element Filter< 1 %
- Sum Formula< 1 %
- RDKit Add Hs< 1 %
- RDKit Diversity Picker< 1 %
- RDKit Kekulizer< 1 %
- Anonymization< 1 %
- Information Gain Calculator< 1 %
- Latitude/Longitude to Coordinate< 1 %
- Fingerprint SUM< 1 %
Loop End (Upto 6 ports)< 1 %- Coordinate Row Filter< 1 %
- Matlab Snippet< 1 %
- Entropy Uncertainty Scorer< 1 %
- File Meta Info (legacy)< 1 %
Table Column to Variable< 1 %Variable to Table Row< 1 %- Read Images< 1 %
Logistic Regression Learner< 1 %- Edit Nominal Domain (Dictionary)< 1 %
- Interactive HiLite Collector< 1 %
Normalizer< 1 %- One to Many (PMML)< 1 %
- Rule Engine Variable (Dictionary)< 1 %
Linear Discriminant Analysis< 1 %Merge Variables< 1 %- Random Matcher< 1 %
- TimeDelay Loop End< 1 %
PMML Predictor< 1 %- DL4J Feedforward Learner (Regression) (legacy)< 1 %
- DL4J Feedforward Predictor (Regression) (legacy)< 1 %
- Rule Viewer (local) (Legacy)< 1 %
Send to Tableau Server (Hyper)< 1 %- IDF< 1 %
- Stop Word Filter< 1 %
Strings To Document< 1 %- Unique Term Extractor< 1 %
- Network Feature Extractor< 1 %
Column Filter QuickForm (legacy)< 1 %XGBoost Linear Ensemble Learner (Regression)< 1 %- CDK to Molecule< 1 %
- RDKit To InChI< 1 %
- RDKit To Molecule< 1 %
- Find Elements< 1 %
Write MDB< 1 %- Molecule Transformation (beta)< 1 %
- Speedy SMILES Component Count< 1 %
- Length< 1 %
Loop End (Upto 4 ports)< 1 %- 2D Kernel Density Plot< 1 %
- Advanced MolConverter< 1 %
- Dipole Moment Calculation< 1 %
- Copy/Move Files (legacy)< 1 %
Variable to Table Column< 1 %Database Reader< 1 %Database SQL Executor< 1 %Recursive Loop Start (2 ports)< 1 %- SOTA Learner< 1 %
Tree Ensemble Learner (Regression)< 1 %Gradient Boosted Trees Learner (Regression)< 1 %- Renderer to Image< 1 %
- Bland-Altman Plot< 1 %
- Cronbach Alpha< 1 %
- Numeric Outliers (Apply)< 1 %
- Wilcoxon Signed-Rank< 1 %
- Linear Discriminant Analysis Compute< 1 %
CASE Switch Variable (End)< 1 %DB Loader< 1 %- DB Sorter< 1 %
- Bit Vector Distances< 1 %
DL Network Executor< 1 %- Boosting Predictor Loop End< 1 %
H2O MOJO Predictor (Classification)< 1 %- Index Query< 1 %
Tableau Writer (Hyper)< 1 %- Term Document Entropy< 1 %
- Dictionary Replacer< 1 %
- RegEx Filter< 1 %
- Bag Of Words Creator< 1 %
- Create Temp Folder< 1 %
- Value Filter Definition (legacy)< 1 %
- Slider Input (legacy)< 1 %
- Container Input (Table)< 1 %
Python Predictor< 1 %- Python Learner (legacy)< 1 %
Python Script (2⇒1)< 1 %XGBoost Tree Ensemble Learner (Regression)< 1 %- String to XML< 1 %
- XSLT< 1 %
- Molecular Properties< 1 %
RDKit Structure Normalizer< 1 %- Geo Distances< 1 %
- Threshold Analyzer< 1 %
- String Similarity< 1 %
- TF-IDF Similarity< 1 %
- Welch Averaging< 1 %
- InChi< 1 %
- Standardizer< 1 %
- Correlation Extension< 1 %
Flow Variable End IF< 1 %- Timed Loop End (3 port)< 1 %
- Timed Loop End (1 port)< 1 %
- Run Garbage Collector< 1 %
- Distance (2-D)< 1 %
- Append Plate Well IDs< 1 %
- Model Fitting< 1 %
- Z-Primes (PC x NC)< 1 %
- Convert to R< 1 %
- Open in R< 1 %
- MolExporter< 1 %
- Strings to Binary Objects< 1 %
CSV Reader< 1 %Database Update< 1 %File Reader< 1 %- Naive Bayes Learner< 1 %
- Hierarchical Clustering (DistMatrix)< 1 %
- Hierarchical Cluster Assigner (local)< 1 %
Numeric Scorer< 1 %Tree Ensemble Predictor< 1 %- Tree Ensemble Predictor< 1 %
- CAIM Applier< 1 %
Number To String (PMML)< 1 %Rule Engine< 1 %- Ruleset Predictor< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Parallel Coordinates (legacy)< 1 %
- Capture Workflow Start< 1 %
SQLite Connector< 1 %Microsoft SQL Server Connector< 1 %- Random Boolean Assigner< 1 %
- String Distances< 1 %
K Nearest Neighbor (Distance Function)< 1 %- Stacked Area Chart (Plotly)< 1 %
- Boosting Learner Loop Start< 1 %
- Prediction Fusion< 1 %
- Cell to PMML< 1 %
- DL4J Feedforward Learner (Classification) (legacy)< 1 %
- JPython Script 1:1 (Legacy)< 1 %
XLS Sheet Appender< 1 %TIBCO File Writer< 1 %- String Matcher< 1 %
- Replacer< 1 %
Document vector< 1 %- Sentence Extractor< 1 %
- Integer Slider Configuration< 1 %
- Range Slider Filter Definition (legacy)< 1 %
Container Input (Variable)< 1 %- String to JSON< 1 %
JSON Writer< 1 %- Labeling Properties< 1 %
- Image Cropper< 1 %
- Image Resizer< 1 %
- Partial Dependence/ICE Plot< 1 %
Python Script (1⇒2)< 1 %Python Edit Variable< 1 %- Python Predictor (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
Dumb Joiner< 1 %- RDKit Interactive Table< 1 %
- RDKit Molecule Extractor< 1 %
- RDKit One Component Reaction< 1 %
- RDKit Count-Based Fingerprint< 1 %
- RDKit SMILES Headers< 1 %
Column Distance< 1 %- Execute JavaScript< 1 %
- Frequency Domain Features (FDF)< 1 %
- Molecule Properties< 1 %
- Unit Converter< 1 %
- XLS Cell Formatter< 1 %
- XLS Cell Commenter< 1 %
- Forge Build Field QSAR< 1 %
- Reaxys Substances< 1 %
- Canonical SMILES< 1 %
- Combinatorial Reaction Enumeration (beta)< 1 %
- Indigo Fingerprint< 1 %
- Molecule Properties< 1 %
- Customer Distributions< 1 %
- PMI Kernel Density Plot< 1 %
- PMI Triangle Scatter Plot< 1 %
- Speedy SMILES Element Count (C, N, O)< 1 %
- Fingerprint to String< 1 %
- Density< 1 %
- Total Count< 1 %
- Generic Run-for-time Loop Start< 1 %
- Timed Loop End (2 port)< 1 %
- Timed Loop End (Upto 4 ports)< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
- MMP Molecule Filter (RDKit)< 1 %
- MMP Molecule Fragment (RDKit)< 1 %
- MMP Show Cuttable Bonds (RDKit)< 1 %
- Benchmark End (Flow Variable)< 1 %
- Benchmark End (Memory Monitoring) (2 ports)< 1 %
- Benchmark Start< 1 %
- Plate Row Converter< 1 %
- Expand Well Position< 1 %
- Split Interval< 1 %
- Range Splitter< 1 %
- Normalize Plates (B-Score)< 1 %
- Groovy Script< 1 %
- Open in Matlab< 1 %
- Matlab Plot< 1 %
Python Snippet< 1 %- Bi Reactor< 1 %
- Chemical Terms< 1 %
- pKa< 1 %
ChemSpider (deprecated)< 1 %- XLS Coloured Writer< 1 %
- ARIMA Predictor< 1 %
- Delete Files (legacy)< 1 %
- FTP Connection (legacy)< 1 %
- Upload (legacy)< 1 %
- URL to File Path< 1 %
Variable to Table column< 1 %- Image to Table< 1 %
Database Drop Table< 1 %Database Table Creator< 1 %Model Reader< 1 %Backward Feature Elimination End< 1 %Loop End (Column Append)< 1 %Column List Loop Start< 1 %Table Row To Variable Loop Start< 1 %- Fuzzy Rule Predictor< 1 %
- PNN Predictor< 1 %
- Silhouette Coefficient< 1 %
Fuzzy c-Means< 1 %- Hierarchical Cluster Assigner< 1 %
- Hierarchical Cluster View< 1 %
- Decision Tree to Image< 1 %
Logistic Regression Predictor< 1 %Regression Predictor< 1 %- SVM Predictor< 1 %
- PCA Inversion< 1 %
Tree Ensemble Learner< 1 %Tree Ensemble Predictor (Regression)< 1 %Random Forest Learner< 1 %Random Forest Learner (Regression)< 1 %Simple Regression Tree Predictor< 1 %Gradient Boosted Trees Predictor< 1 %- Tree Ensemble Learner< 1 %
Random Forest Predictor< 1 %- PMML Simple Regression Tree Predictor< 1 %
- Distance Matrix Pair Extractor< 1 %
- Perl Scripting< 1 %
- Create Byte Vector< 1 %
String To Number< 1 %- String to SVG< 1 %
Linear Correlation< 1 %- Edit Nominal Domain< 1 %
- Many to One (PMML)< 1 %
- Denormalizer (PMML)< 1 %
- Nominal Probability Distribution Creator< 1 %
- Target Shuffling< 1 %
Odds and Risk Ratios< 1 %- Kaplan-Meier Estimator< 1 %
Shapiro Wilk Normality Test< 1 %- Kolmogorov-Smirnov Test< 1 %
- Create Temp Dir (legacy)< 1 %
Statistics< 1 %Parquet Writer< 1 %Vertica Connector< 1 %- SDF Extractor< 1 %
- SDF Stripper< 1 %
- Fingerprint Bayesian Predictor< 1 %
- Amazon Comprehend (Sentiment)< 1 %
- Parallel Chunk End (multi port)< 1 %
- Parallel Chunk Start< 1 %
- MySQL Connector< 1 %
- Oracle Connector< 1 %
- PostgreSQL Connector< 1 %
- DB Transaction Start< 1 %
- DB Table Selector< 1 %
- One Rule Inserter< 1 %
- Random Number Assigner (Apache)< 1 %
- Java Distance< 1 %
- Matrix Distance< 1 %
- Distance Matrix Writer< 1 %
- Continuous Error Plot (Plotly)< 1 %
- Contour Plot (Plotly)< 1 %
- Error Bars Plot (Plotly)< 1 %
- Parallel Coordinates Plot (JavaScript)< 1 %
- PMML Ensemble Predictor< 1 %
- Cell to Model< 1 %
Table to HTML< 1 %- Table to HTML (legacy)< 1 %
- MoSS< 1 %
- DL4J Feedforward Learner (Pretraining) (legacy)< 1 %
- H2O k-Means< 1 %
- H2O Generalized Linear Model Learner (Regression)< 1 %
- H2O Numeric Scorer< 1 %
- Item Set Finder (Borgelt)< 1 %
- JPython Function (Legacy)< 1 %
- LIBSVMLearner< 1 %
- OSM Map to Image< 1 %
XLS Reader< 1 %Excel Reader (XLS)< 1 %Excel Reader (XLS)< 1 %R Learner< 1 %Open TIBCO Spotfire< 1 %- SSH Connector< 1 %
Tableau Writer (TDE)< 1 %- Word Vector Apply (legacy)< 1 %
- Doc2Vec Learner (legacy)< 1 %
- Category to Class< 1 %
- Keygraph Keyword Extractor< 1 %
- Markup Tag Filter< 1 %
- Tika Language Detector< 1 %
- Kuhlen Stemmer< 1 %
- N Chars Filter< 1 %
POS Filter< 1 %- Dictionary Tagger< 1 %
- POS Tagger< 1 %
Document Data Extractor< 1 %Document vector hashing< 1 %- Meta Info Extractor< 1 %
- Term Vector< 1 %
- t-SNE (L. Jonsson)< 1 %
- Path to String (Variable)< 1 %
Column Filter Configuration< 1 %- Date&Time Input (legacy)< 1 %
- Date&Time Widget< 1 %
- JSON Row Combiner< 1 %
- Container Output (JSON)< 1 %
- JSON to Table< 1 %
- Kafka Producer< 1 %
- Quantile Filter< 1 %
- Data Row to Image< 1 %
- Auto Crop< 1 %
- Image Normalizer< 1 %
- Apply Color Settings To Labels< 1 %
- Label Transformer< 1 %
- Add...< 1 %
- Gaussian Blur...< 1 %
MongoDB Writer< 1 %- SubGraph Extractor< 1 %
- Assign Partition< 1 %
- Network Viewer< 1 %
- Multiobjective Score Computation< 1 %
- Parameter Optimization Loop Start< 1 %
- Parameter Optimization Loop Start (Table)< 1 %
Python Script (1⇒1)< 1 %Python Learner< 1 %Python Script (2⇒2)< 1 %- Webpage Retriever< 1 %
- Block Programmatically (Table)< 1 %
- Disturber Node< 1 %
- Extract Time Window (legacy)< 1 %
XGBoost Linear Ensemble Learner< 1 %XGBoost Tree Ensemble Learner< 1 %- XML Column Combiner< 1 %
- XML Row Combine and Write< 1 %
- XML Row Combiner< 1 %
XML Writer< 1 %- Discretise< 1 %
Table to HTML String< 1 %Binary Scorer< 1 %- Fingerprint Similarity< 1 %
- 3D RMSD< 1 %
- RDKit Generate Coords< 1 %
- RDKit Chemical Transformation< 1 %
RDKit Functional Group Filter< 1 %- RDKit Molecule Catalog Filter< 1 %
- RDKit Salt Stripper< 1 %
- RDKit Two Component Reaction< 1 %
- Text Classifier Learner< 1 %
- Text Classifier Predictor< 1 %
- MapQuest Geocoder< 1 %
Map Viewer< 1 %- Coordinate to Latitude/Longitude< 1 %
Hash Calculator< 1 %RMSE Calculator< 1 %- URL Domain Extractor< 1 %
- URL Extractor< 1 %
- HTTP Retriever< 1 %
- HTML Parser< 1 %
- Form Encoded HTTP Entity Creator< 1 %
Click< 1 %- Navigate< 1 %
Views
- This node has no views
Workflows
_01_PMR_AnalysisKNIME Hub- !Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub
- (3D) Fragment library design workflowKNIME Hub
- (Optional)_Linear_RegressionKNIME Hub
- [Latest] Consolidated 3 Mar 1210KNIME Hub
- Show all 5859 workflows
Links
- How do i average a column to become one number onlyby armingrudd on 2020-08-02forum.knime.com/p/98698
- Converting NaNs to missing valuesby qqilihq on 2021-01-31forum.knime.com/p/114672
- 0.3 IS NOT EQUAL 0.3 ?!?!?!by qqilihq on 2021-01-01forum.knime.com/p/112141
- Change a single row in a columnby armingrudd on 2020-05-12forum.knime.com/p/90784
- How can I divide these numbers, which is the standard price, by the unit price?by knimediger on 2023-07-25forum.knime.com/p/230024
- Show all 20 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.