This node takes a list of user-defined rules and tries to match them
to each row in the input table. If a rule matches, its outcome value
is added into a new column.
The first matching rule in order of definition determines the outcome.
Each rule is represented by a line.
To add comments, start a line with
//
(comments can not be placed in the same line as a rule). Anything after // will not be interpreted as a rule.
Rules consist of a condition part (antecedent), which must
evaluate to
true
or
false
, and an outcome (consequent, after the => symbol) which is put into
the new column if the rule matches.
The outcome of a rule may be any of the following: a string (between " or /), a number, a boolean constant, a reference
to another column or the value of a flow variable value.
The type of the outcome column is the common super
type of all possible
outcomes (including the rules that can never
match).
If no rule matches, the outcome is a missing value.
Columns are given by their name surrounded by $, numbers are given in the usual decimal representation. Note that strings must not contain (double-)quotes. Flow variables are represented by $${ TypeCharacterAndFlowVarName }$$ . The TypeCharacter should be 'D' for double (real) values, 'I' for integer values and 'S' for strings. You can insert column names or flow variables by hand or by clicking in the respective lists in the dialog.
The logical expressions can be grouped with parentheses. The
precedence rules for them are the following: NOT binds most, AND,
XOR and finally OR the least.
Comparison operators always take
precedence over logical connectives.
All operators (and their names)
are case-sensitive.
The
ROWID
represents the row key string, the
ROWINDEX
is a the index of the row (first row has
0
value), while
ROWCOUNT
stands for the number of rows in the table.
Some example rules (each should be in one line):
// This is a comment $Col0$ > 0 => "Positive"When the values in Col0 are greater than 0, we assign Positive to the result column value (if no previous rule matched).
$Col0$ = "Active" AND $Col1$ <= 5 => "Outlier"You can combine conditions.
$Col0$ LIKE "Market Street*" AND
($Col1$ IN ("married", "divorced")
OR $Col2$ > 40) => "Strange"
$Col0$ MATCHES $${SFlowVar0}$$ OR $$ROWINDEX$$ < $${IFlowVar1}$$ =>
$Col0$
With parentheses you can combine multiple conditions. The result in
the second case comes from one of the columns.
$Col0$ > 5 => $${SCol1}$$
The result can also come from a flow variable.
You can use either Ctrl+Space to insert predefined parts, or select them from the upper controls.
The following comparisons result true (other values are neither less, nor greater or equal to missing and NaN values):
- ? =,<=,>= ?
- NaN =,<=,>= NaN
Options
Rule Editor
Popular Successors
- Rule Engine10 %
- GroupBy9 %
Row Filter (deprecated)7 %- Column Filter7 %
- Concatenate5 %
- Excel Writer4 %
- Rule-based Row Filter4 %
- String Manipulation4 %
- Math Formula3 %
- Column Resorter2 %
- Missing Value2 %
Row Splitter (deprecated)2 %- String to Number2 %
- Rule-based Row Splitter1 %
- Pivot1 %
- CSV Writer1 %
- Column Expressions (legacy)1 %
- Sorter1 %
- Constant Value Column1 %
- String to Date&Time< 1 %
- Duplicate Row Filter< 1 %
- Number to String< 1 %
- Nominal Value Row Filter< 1 %
- Partitioning< 1 %
- Loop End< 1 %
- Cell Splitter< 1 %
- Value Counter< 1 %
- Table Manipulator< 1 %
- Column Combiner< 1 %
- Scorer< 1 %
- Date&Time Part Extractor< 1 %
- DB Writer< 1 %
- Column Renamer< 1 %
- Group Loop Start< 1 %
- Reference Row Filter< 1 %
- Math Formula (Multi Column)< 1 %
- IF Switch< 1 %
- Date&Time Difference< 1 %
- Column Merger< 1 %
- String Manipulation (Multi Column)< 1 %
- Nominal Value Row Splitter< 1 %
- Statistics< 1 %
Cell Replacer< 1 %- Color Manager< 1 %
- Date&Time to String< 1 %
- Date&Time Shift< 1 %
- String Replacer< 1 %
- Column Appender< 1 %
- Column Aggregator< 1 %
- Date&Time-based Row Filter< 1 %
Joiner< 1 %- Cross Joiner< 1 %
- Normalizer< 1 %
- Missing Value Column Filter< 1 %
- Lag Column< 1 %
- XLS Control Table Generator< 1 %
- Unpivot< 1 %
- Number Rounder< 1 %
- Table Row to Variable Loop Start< 1 %
- RowID< 1 %
- Table Row to Variable< 1 %
- Java Snippet< 1 %
- Column Renamer (Dictionary)< 1 %
- Numeric Binner< 1 %
- One to Many< 1 %
- Rule Engine (Dictionary)< 1 %
Variable to Table Column< 1 %- Google Sheets Updater< 1 %
- Rank< 1 %
- End IF< 1 %
- Column Splitter< 1 %
- DB Update< 1 %
- Chunk Loop Start< 1 %
- CASE Switch Start< 1 %
- Statistics View< 1 %
- Value Lookup< 1 %
- Column Rename (Regex)< 1 %
- Linear Correlation< 1 %
- DB Insert< 1 %
- Column Auto Type Cast< 1 %
- Create Collection Column< 1 %
Merge Variables< 1 %Regression Predictor< 1 %- Send to Tableau Server< 1 %
- Reference Row Splitter< 1 %
- Reference Column Filter< 1 %
- CASE Switch End< 1 %
- Category to Number< 1 %
- String Splitter (Regex)< 1 %
- Table Writer< 1 %
- Case Converter< 1 %
- Parquet Writer< 1 %
- DB Loader< 1 %
- Loop End (Column Append)< 1 %
- Table Transposer< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Moving Aggregator< 1 %
- Auto-Binner< 1 %
- Empty Table Switch< 1 %
- DB Table Creator< 1 %
Excel Writer (XLS)< 1 %- Column Comparator< 1 %
- Bar Chart (JFreeChart)< 1 %
Database Looping< 1 %Column Rename< 1 %Loop End (2 ports)< 1 %- Scorer (JavaScript)< 1 %
- Table Validator (Reference)< 1 %
- String to Number (PMML)< 1 %
Number To String (PMML)< 1 %- Data Explorer< 1 %
- Table View< 1 %
- Columns to JSON< 1 %
- Recursive Loop End< 1 %
- Row Filter (Labs)< 1 %
- Row Sampling< 1 %
Rank Correlation< 1 %- Modify Date< 1 %
Logistic Regression Learner< 1 %- Missing Value (Apply)< 1 %
Excel Writer (XLS)< 1 %- Fingerprints< 1 %
- Decision Tree Learner< 1 %
- Numeric Outliers< 1 %
- X-Partitioner< 1 %
- Edit Numeric Domain< 1 %
- String Replacer (Dictionary)< 1 %
- Pie Chart< 1 %
- String to Date/Time (legacy)< 1 %
- Variable Condition Loop End< 1 %
Excel Sheet Appender (XLS)< 1 %- Category to Class< 1 %
CSV Writer< 1 %Numeric Scorer< 1 %String To Number (PMML)< 1 %- Bar Chart (JavaScript)< 1 %
- Java Snippet Row Filter< 1 %
IF Switch (Flow Variable Value)< 1 %- Molecule Type Cast< 1 %
- Java Snippet (simple)< 1 %
Recursive Loop Start< 1 %- k-Means< 1 %
- Ungroup< 1 %
- Tableau Writer< 1 %
- Modify Time< 1 %
- Table to HTML String< 1 %
- Row Splitter (Labs)< 1 %
- Counter Generation< 1 %
- Breakpoint< 1 %
Naive Bayes Predictor< 1 %Gradient Boosted Trees Predictor< 1 %- Add Empty Rows< 1 %
TIBCO File Writer< 1 %- Interactive Range Slider Filter Widget< 1 %
- Python Script (legacy)< 1 %
- Decision Tree Predictor< 1 %
PCA< 1 %- Double to Integer< 1 %
- DB Merge< 1 %
- Association Rule Learner (Borgelt)< 1 %
- R Snippet (2:1)< 1 %
- Parallel Chunk End< 1 %
Microsoft Authenticator (Deprecated)< 1 %- Value Filter (legacy)< 1 %
- Table Editor (JavaScript)< 1 %
- Collection to String< 1 %
- Column List Loop Start< 1 %
- Linear Regression Learner< 1 %
- String Manipulation (Variable)< 1 %
- Rule Engine Variable< 1 %
- Conditional Box Plot (legacy)< 1 %
- Path to String< 1 %
- Create Date&Time Range< 1 %
- RDKit From Molecule< 1 %
- XLS Font Formatter< 1 %
- Strings to Binary Objects< 1 %
- Variable to Table Column< 1 %
- Regression Predictor< 1 %
Random Forest Learner< 1 %- Domain Calculator< 1 %
- Crosstab< 1 %
- One Row to Many< 1 %
- ROC Curve (JavaScript)< 1 %
- Scatter Plot (JavaScript)< 1 %
- Variable Loop End< 1 %
Naive Bayes Learner< 1 %- Column Name Extractor< 1 %
String Replace (Dictionary)< 1 %- Independent groups t-test< 1 %
CASE Switch Data (End)< 1 %- Box Plot< 1 %
- One Rule Inserter< 1 %
- Python View (legacy)< 1 %
- RDKit Descriptor Calculation< 1 %
- String Similarity< 1 %
- Write To Excel Template (deprecated)< 1 %
Table Column to Variable< 1 %Table Reader< 1 %- Number to String (PMML)< 1 %
- Extract Table Dimension< 1 %
- Interactive Pie chart (legacy)< 1 %
- SDF Writer< 1 %
- Send to Power BI< 1 %
- Column Selection Configuration< 1 %
- Line Plot (JavaScript)< 1 %
- Date Field Extractor (legacy)< 1 %
- RDKit Interactive Table< 1 %
- Regex Extractor< 1 %
- XLS Conditional Formatter< 1 %
- Catch Errors (Data Ports)< 1 %
- Table Column to Variable< 1 %
- Table Creator< 1 %
Recursive Loop End (2 ports)< 1 %- Logistic Regression Learner< 1 %
- Numeric Scorer< 1 %
- Interactive Table (legacy)< 1 %
- Scatter Plot Matrix< 1 %
- Excel Reader< 1 %
- Table to JSON< 1 %
- Recursive Loop Start< 1 %
Gradient Boosted Trees Predictor< 1 %- Random Forest Learner< 1 %
Number To String< 1 %- Rule Engine Variable (Dictionary)< 1 %
- Paired t-test< 1 %
- Scatter Matrix (legacy)< 1 %
- ROC Curve (legacy)< 1 %
- Bar Chart< 1 %
Parquet Writer< 1 %- Microsoft SQL Server Connector< 1 %
- 2D Density Plot (Plotly)< 1 %
- Line Plot (Plotly)< 1 %
- Variable Expressions (legacy)< 1 %
- Multivariate Z-Primes< 1 %
Python Plot< 1 %- Regex To List< 1 %
Table Row to Variable< 1 %- Fuzzy Rule Learner< 1 %
- Entropy Scorer< 1 %
- Create Bit Vector< 1 %
- Cell Splitter By Position< 1 %
- Joiner< 1 %
- One to Many (PMML)< 1 %
- Reference Column Resorter< 1 %
- Row Aggregator< 1 %
CASE Switch Data (Start)< 1 %- Send Email< 1 %
- Box Plot (legacy)< 1 %
- Histogram< 1 %
- Scatter Plot (Plotly)< 1 %
- Replacer< 1 %
- String to Path< 1 %
Python Script (1⇒2)< 1 %- Table to R< 1 %
- RDKit Substructure Filter< 1 %
- Benchmark End (Memory Monitoring)< 1 %
- Vector Length Normalization< 1 %
- Advanced MolConverter< 1 %
- Try (Data Ports)< 1 %
- Extract Variables (Data)< 1 %
Counting Loop Start< 1 %Variable Condition Loop End< 1 %Generic Loop Start< 1 %Recursive Loop End< 1 %- K Nearest Neighbor< 1 %
- Polynomial Regression Learner< 1 %
- SMOTE< 1 %
Gradient Boosted Trees Learner< 1 %- Tree Ensemble Learner (Regression)< 1 %
- Random Forest Learner (Regression)< 1 %
- Bootstrap Sampling< 1 %
Column Appender< 1 %- Column to Grid< 1 %
- Table Validator< 1 %
Double To Int< 1 %- Filter Apply Row Splitter< 1 %
- Numeric Row Splitter< 1 %
- Top k Row Filter< 1 %
- Proportion Test< 1 %
- Size Manager< 1 %
- Table to Spark< 1 %
- Parallel Chunk Start< 1 %
- DB Connector< 1 %
- Parameterized DB Query Reader< 1 %
- Conditional Box Plot (JavaScript)< 1 %
- OSM Map View< 1 %
- TF< 1 %
- Keygraph Keyword Extractor< 1 %
- Number Filter< 1 %
- RegEx Filter< 1 %
- Create Temp Folder< 1 %
- Multi Feature Inserter< 1 %
- Multiobjective Score Computation< 1 %
- R View (Table)< 1 %
- String to Duration< 1 %
XGBoost Tree Ensemble Learner< 1 %- XLS Row and Column Sizer< 1 %
IF Switch (Flow Variable Value)< 1 %- Normalize Plates (Z-Score)< 1 %
- 2D/3D Scatterplot< 1 %
- ARIMA Learner< 1 %
- Split Collection Column< 1 %
- URL to File Path< 1 %
Table Row To Variable Loop Start< 1 %Database Update< 1 %Database Writer< 1 %Database Drop Table< 1 %- Variable Creator< 1 %
- Generic Loop Start< 1 %
PCA Apply< 1 %Scorer< 1 %- PCA Compute< 1 %
- Gradient Boosted Trees Predictor< 1 %
- Random Forest Predictor< 1 %
- Simple Regression Tree Learner< 1 %
String To Number< 1 %- Correlation Filter< 1 %
- Edit Nominal Domain< 1 %
Missing Value< 1 %- Denormalizer< 1 %
- Numeric Binner (PMML)< 1 %
- Ruleset Predictor< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Numeric Outliers (Apply)< 1 %
- Kruskal-Wallis Test< 1 %
- Number Format Manager< 1 %
Color Appender< 1 %- Save Workflow< 1 %
- Scatter Plot< 1 %
- ORC Writer< 1 %
- Empty Table Creator< 1 %
- Random Number Assigner< 1 %
- Radar Plot Appender< 1 %
- Document Data Extractor< 1 %
- String to Term< 1 %
- Transfer Files (Table)< 1 %
- Date&Time Input (legacy)< 1 %
- Heatmap (JavaScript)< 1 %
- Table View (JavaScript)< 1 %
- Column Filter Widget< 1 %
- Value Selection Widget< 1 %
- Don't Save End< 1 %
- Create FileStore Column< 1 %
- Moving Average< 1 %
- XML Column Combiner< 1 %
- Anonymization< 1 %
- Latitude/Longitude to Coordinate< 1 %
- XLS Background Colorizer< 1 %
- XLS Sheet Properties< 1 %
- Configurable IF/CASE Switch< 1 %
- Missing to Empty Collection< 1 %
Expand Well Position< 1 %- Create Interval< 1 %
- Z-Primes (PC x NC)< 1 %
- R Plot< 1 %
- MolConverter< 1 %
- Binary Objects to Strings< 1 %
Variable to Table Column< 1 %- ARFF Writer< 1 %
Database Table Creator< 1 %- Image Writer (Table)< 1 %
Table Writer< 1 %- Feature Selection Filter< 1 %
- X-Aggregator< 1 %
- Naive Bayes Learner< 1 %
- Cluster Assigner< 1 %
- Association Rule Learner< 1 %
- Gradient Boosted Trees Learner< 1 %
- Gradient Boosted Trees Learner (Regression)< 1 %
- Simple Regression Tree Predictor< 1 %
Concatenate (Optional in)< 1 %- Binner (Dictionary)< 1 %
Cell Splitter< 1 %- Number to Category (Apply)< 1 %
- Extract Missing Value Cause< 1 %
- HiLite Row Splitter< 1 %
- Low Variance Filter< 1 %
- Column Filter (PMML)< 1 %
- Row to Column Names< 1 %
- Set Operator< 1 %
- Shuffle< 1 %
- Table Difference Finder< 1 %
- Ruleset Editor< 1 %
- Rank Correlation< 1 %
- Kaplan-Meier Estimator< 1 %
CASE Switch Variable (Start)< 1 %- Merge Variables< 1 %
- Timer Info< 1 %
- Lift Chart (legacy)< 1 %
- Scatter Plot (legacy)< 1 %
- Shape Manager< 1 %
- PMML Transformation Apply< 1 %
- ROC Curve< 1 %
- PostgreSQL Connector< 1 %
- DB Delete (Table)< 1 %
- Random Number Assigner (Apache)< 1 %
- Keras Network Executor< 1 %
- Keras Network Learner< 1 %
- Box Plot (JavaScript)< 1 %
- Bubble Chart (Plotly)< 1 %
- Radar Plot (Plotly)< 1 %
- H2O MOJO Predictor (Classification)< 1 %
- Math Formula (Variable)< 1 %
- HeatMap (JFreeChart)< 1 %
- Scatter Plot (JFreeChart)< 1 %
- String Matcher< 1 %
- Dictionary Replacer< 1 %
- Punctuation Erasure< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- Path to String (Variable)< 1 %
- Set Files/Folders Permissions< 1 %
- Value Selection Configuration< 1 %
- Credentials Input (legacy)< 1 %
- String to JSON< 1 %
- JSON Transformer< 1 %
- Image Resizer< 1 %
- Image Viewer< 1 %
- Binary Classification Inspector< 1 %
Python Script (2⇒1)< 1 %- Date&Time to legacy Date&Time< 1 %
- UNIX Timestamp to Date&Time< 1 %
- Extract Duration Fields< 1 %
- Preset Date/Time (legacy)< 1 %
- Column to XML< 1 %
- XPath< 1 %
- Remove Empty Rows< 1 %
- RDKit Fingerprint< 1 %
- Google Address Geocoder< 1 %
Regex Extractor< 1 %- Execute JavaScript< 1 %
- XLS Border Formatter< 1 %
- XLS Cell Formatter< 1 %
- XLS Control Table from Cell Range< 1 %
- TIBCO Spotfire File Writer< 1 %
- Multiport Loop End< 1 %
- Configurable End IF/CASE< 1 %
- Number Formatter< 1 %
- Plate Heatmap Viewer< 1 %
- Python Snippet< 1 %
- MolExporter< 1 %
- Copy/Move Files (legacy)< 1 %
- String to URI< 1 %
- Upload (legacy)< 1 %
- Wait...< 1 %
- Inject Variables (Data)< 1 %
Table Column to Variable< 1 %Table Column to Variable< 1 %Table Row to Variable< 1 %- Variable to Table Row< 1 %
- Read Images< 1 %
- Table to Image< 1 %
Database Delete< 1 %- CSV Reader< 1 %
- Table Reader< 1 %
- Feature Selection Loop Start (1:1)< 1 %
Loop End< 1 %- Counting Loop Start< 1 %
Interval Loop Start< 1 %- Naive Bayes Predictor< 1 %
- Silhouette Coefficient< 1 %
- Fuzzy c-Means< 1 %
- Hierarchical Clustering< 1 %
- DBSCAN< 1 %
- RProp MLP Learner< 1 %
- Logistic Regression Predictor< 1 %
- SVM Learner< 1 %
- SVM Predictor< 1 %
- PCA< 1 %
Random Forest Predictor< 1 %Gradient Boosted Trees Learner (Regression)< 1 %- Gradient Boosted Trees Predictor (Regression)< 1 %
- Tree Ensemble Predictor< 1 %
- Random Forest Predictor (Regression)< 1 %
- Expand Bit Vector< 1 %
- Many to One< 1 %
- CAIM Binner< 1 %
- Equal Size Sampling< 1 %
- Reference Column Splitter< 1 %
- Constant Value Column Filter< 1 %
- Filter Apply< 1 %
- Subset Matcher< 1 %
- Normalizer (Apply)< 1 %
- Normalizer (PMML)< 1 %
- Cell Updater< 1 %
- Table Splitter< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Odds and Risk Ratios< 1 %
- Shapiro-Wilk Test< 1 %
- One-way ANOVA< 1 %
- Single sample t-test< 1 %
- Wilcoxon-Mann-Whitney Test< 1 %
- Cache< 1 %
- Extract Table Spec< 1 %
- Histogram (legacy)< 1 %
- Interactive Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Line Plot (legacy)< 1 %
- Density Plot< 1 %
- Heatmap< 1 %
- Line Plot< 1 %
- Sunburst Chart< 1 %
- Databricks File System Connection (legacy)< 1 %
Parquet Writer< 1 %- Capture Workflow End< 1 %
- SDF Inserter< 1 %
MySQL Connector< 1 %- DB Connection Closer< 1 %
- DB Query Reader< 1 %
- DB SQL Executor< 1 %
- Random Matcher< 1 %
- Numeric Distances< 1 %
- String Distances< 1 %
- Similarity Search< 1 %
- DL Python Network Learner< 1 %
- 3D Scatter Plot (Plotly)< 1 %
- Histogram (JavaScript)< 1 %
- Pie/Donut Chart (JavaScript)< 1 %
- Stacked Area Chart (Plotly)< 1 %
- Sunburst Chart (JavaScript)< 1 %
- Violin Plot (Plotly)< 1 %
- OpenBabel< 1 %
- External Tool< 1 %
- Table to H2O< 1 %
- GroupBy Bar Chart (JFreeChart)< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Line Chart (JFreeChart)< 1 %
- Pie Chart (JFreeChart)< 1 %
- Index Query< 1 %
- Geo-Coordinate Row Filter< 1 %
Excel Reader (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %- Excel Cell Updater< 1 %
- SharePoint Online List Writer< 1 %
- Java IF (Table)< 1 %
- Java Snippet Row Splitter< 1 %
Send to Tableau Server (TDE)< 1 %- Case Converter< 1 %
- Dictionary Tagger< 1 %
- POS Tagger< 1 %
Bag of Words Creator< 1 %- Bag Of Words Creator< 1 %
- Strings to Document< 1 %
- Tag Cloud< 1 %
- List Files/Folders< 1 %
- Transfer Files< 1 %
- Google Sheets Reader< 1 %
- Google Sheets Appender< 1 %
- Google Sheets Writer< 1 %
- Column Filter Configuration< 1 %
- Nominal Row Filter Configuration< 1 %
- CSS Editor< 1 %
- Column Filter (legacy)< 1 %
- Value Filter Definition (legacy)< 1 %
- Slider Input (legacy)< 1 %
- Column Selection (legacy)< 1 %
- Decision Tree View (JavaScript)< 1 %
- Generic JavaScript View (JavaScript)< 1 %
- Lift Chart (JavaScript)< 1 %
- Tag Cloud (JavaScript)< 1 %
- Tile View (JavaScript)< 1 %
- Interactive Value Filter Widget< 1 %
- Nominal Row Filter Widget< 1 %
- Container Output (Table)< 1 %
- JSON Writer< 1 %
- JSON Path< 1 %
- JSON to Table< 1 %
- Object Inserter< 1 %
- Add Table to R< 1 %
- R Snippet< 1 %
- Data to Report (BIRT)< 1 %
- GET Request< 1 %
- POST Request< 1 %
- Webpage Retriever< 1 %
- Duration to Number< 1 %
Extract Date&Time Fields< 1 %- Modify Time Zone< 1 %
- Date/Time Shift (legacy)< 1 %
- Time Difference (legacy)< 1 %
- Time Generator (legacy)< 1 %
- Mask Date/Time (legacy)< 1 %
- Workflow Service Output< 1 %
- XGBoost Predictor< 1 %
Binary Scorer< 1 %- Molecular Properties< 1 %
- Table to Event Log< 1 %
- RDKit Canon SMILES< 1 %
- RDKit To InChI< 1 %
- RDKit Substructure Counter< 1 %
- Date Extractor< 1 %
- Hash Calculator< 1 %
- Threshold Analyzer< 1 %
- HTML Node to Text< 1 %
- Form Encoded HTTP Entity Creator< 1 %
- XLS Sheet Selector< 1 %
- Create Well Position< 1 %
- logP< 1 %
Database Connector< 1 %List Files< 1 %Recursive Loop Start (2 ports)< 1 %- Fuzzy Rule Predictor< 1 %
- Normalizer Apply (PMML)< 1 %
- Target Shuffling< 1 %
- Enrichment Plotter (legacy)< 1 %
- HiLite Table (legacy)< 1 %
Hive Loader (legacy)< 1 %- Conditional Label Assigner< 1 %
- Stacked Area Chart (JavaScript)< 1 %
- DL4J Feedforward Learner (Pretraining) (legacy)< 1 %
XLS Sheet Appender< 1 %- Document Data Assigner< 1 %
- Document Viewer< 1 %
- Weka Predictor (3.7)< 1 %
- Date&Time Configuration< 1 %
- Range Slider Filter Definition (legacy)< 1 %
- R Learner< 1 %
- Window Loop Start< 1 %
- Result< 1 %
- Text Classifier Predictor< 1 %
- HTTP Retriever< 1 %
- Find Elements< 1 %
- Window Slider< 1 %
- XLS Control Table Merger< 1 %
- Uniquify IDs< 1 %
- Plate Row Converter< 1 %
- Expand Well Position< 1 %
- Binning Apply< 1 %
Python Snippet< 1 %- Delete Files (legacy)< 1 %
- Zip Files (legacy)< 1 %
- Try (Variable Ports)< 1 %
- Create File Name (legacy)< 1 %
Variable to Table Row< 1 %- PNN Learner (DDA)< 1 %
- MultiLayerPerceptron Predictor< 1 %
- Category to Number (Apply)< 1 %
- Renderer to Image< 1 %
- Numeric Median Test< 1 %
CASE Switch Variable (End)< 1 %- Size Appender< 1 %
- DB Table Selector< 1 %
- Distance Matrix Calculate< 1 %
- Boosting Learner Loop Start< 1 %
Table to HTML< 1 %- Item Set Finder (Borgelt)< 1 %
- Bubble Chart (JFreeChart)< 1 %
- LIBSVMPredictor< 1 %
Document Data Extractor< 1 %- Tags to String< 1 %
- Term to String< 1 %
- Files/Folders Meta Info< 1 %
- Google Sheets Connector< 1 %
Python Predictor< 1 %Python Script (1⇒1)< 1 %- R Predictor< 1 %
- Table Difference Checker< 1 %
- Extract Time Window (legacy)< 1 %
- String to XML< 1 %
- CDK to Molecule< 1 %
- RDKit Molecule to SVG< 1 %
- Time Domain Features (TDF)< 1 %
- CIR< 1 %
- Feature Remover< 1 %
- Empty Collection to Missing< 1 %
- Split Columns by Header< 1 %
- Combine Columns by Header< 1 %
- BinningAnalysis< 1 %
- Normalize Plates (NPI)< 1 %
- Normalize Plates (POC)< 1 %
- Automated Matched Pairs< 1 %
Active Learn Loop Start< 1 %- ARIMA Visualization< 1 %
Binary Objects to Files< 1 %Variable to Table Row< 1 %File Reader< 1 %- Feature Selection Loop Start (2:2)< 1 %
- PNN Predictor< 1 %
- Decision Tree to Image< 1 %
K Nearest Neighbor< 1 %- PCA Apply< 1 %
PMML Gradient Boosted Trees Predictor< 1 %- String to SVG< 1 %
- CAIM Applier< 1 %
Column Filter< 1 %Normalizer< 1 %- Denormalizer (PMML)< 1 %
- Kolmogorov-Smirnov Test< 1 %
- Wilcoxon Signed-Rank< 1 %
- Parallel Coordinates (legacy)< 1 %
DB Loader< 1 %- DB Table Remover< 1 %
- Random Label Assigner< 1 %
- Random Label Assigner (Data)< 1 %
- Random Boolean Assigner< 1 %
- TimeDelay Loop Start< 1 %
- Matrix Distance< 1 %
- k-Medoids< 1 %
- Cell to Model< 1 %
- MoSS< 1 %
- H2O MOJO Predictor (Regression)< 1 %
- JPython Function (Legacy)< 1 %
Excel Reader (XLS)< 1 %Send to Power BI< 1 %- Doc2Vec Learner (legacy)< 1 %
- Term Co-Occurrence Counter< 1 %
- t-SNE (L. Jonsson)< 1 %
- Shapefile writer< 1 %
Column Filter Configuration< 1 %- Text Output (legacy)< 1 %
- String Input (legacy)< 1 %
- Column Selection Widget< 1 %
- JSON Path (Dictionary)< 1 %
- Binary Image Operations< 1 %
- Slice Loop Start< 1 %
- SHAP Loop End< 1 %
- Parameter Optimization Loop End< 1 %
Python Script (1⇒2)< 1 %Python View< 1 %- Python Source (legacy)< 1 %
- Time Field Extractor (legacy)< 1 %
XML Writer< 1 %- 2D Coordinates< 1 %
- Fingerprint Similarity< 1 %
- Substructure Search< 1 %
- BERT Classification Learner< 1 %
- MapQuest Geocoder< 1 %
Map Viewer< 1 %Web Searcher< 1 %- Alert< 1 %
Find Elements< 1 %- Wait< 1 %
- Duplicate Filter< 1 %
XLS Formatter (apply)< 1 %- XLS Hyperlinker< 1 %
- Canonical SMILES< 1 %
- Molecule Properties< 1 %
- Demand Curve< 1 %
- Message Slack channel< 1 %
- Message Slack User< 1 %
- TIBCO Spotfire Information Link Reader< 1 %
- Templated Conformer Generation (RDKit)< 1 %
- Speedy SMILES Heavy Atom Count (HAC)< 1 %
- Is Empty< 1 %
Flow Variable IF Switch< 1 %Flow Variable IF Switch (Flow Variable Value)< 1 %Flow Variable IF Switch (Flow Variable Value)< 1 %Loop End (Upto 4 ports)< 1 %Loop End (Upto 6 ports)< 1 %- Timed Loop End (1 port)< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
- Run Garbage Collector< 1 %
- Benchmark End< 1 %
- Benchmark Start (2 ports)< 1 %
- List To Set< 1 %
- URL Decode< 1 %
- URL Encode< 1 %
- Range Filter< 1 %
- Range Splitter< 1 %
- Normalize Plates (B-Score)< 1 %
- Outlier Removal< 1 %
- SSMD (PC x NC)< 1 %
- Python Plot< 1 %
- R Snippet< 1 %
- Open in R< 1 %
- Chemical Fingerprint< 1 %
- ECFP/FCFP< 1 %
- JChem Update< 1 %
- Standardizer< 1 %
- MarvinView< 1 %
- Fingerprints Expander< 1 %
- Desirability Ranking< 1 %
- Fingerprint Similarity< 1 %
- Free-Wilson Matched Pairs< 1 %
- Table to String< 1 %
- Virtual Screening Metrics< 1 %
- XLS Coloured Writer< 1 %
- Active Learning Loop Start< 1 %
- ARIMA Predictor< 1 %
- Create Directory (legacy)< 1 %
File Meta Info< 1 %- File Meta Info (legacy)< 1 %
- SSH Connection (legacy)< 1 %
- Catch Errors (Var Ports)< 1 %
- Active Branch Inverter< 1 %
Database Joiner< 1 %Database Reader< 1 %Database SQL Executor< 1 %Parameterized Database Query< 1 %- Java Edit Variable< 1 %
Backward Feature Elimination Filter< 1 %Backward Feature Elimination End< 1 %Backward Feature Elimination Start (1:1)< 1 %- Feature Selection Loop End< 1 %
Loop End (Column Append)< 1 %Table Row To Variable Loop Start< 1 %Variable Loop End< 1 %- Hierarchical Clustering (DistMatrix)< 1 %
Decision Tree Learner< 1 %- MDS (DistMatrix)< 1 %
- MDS Projection< 1 %
PCA Compute< 1 %Logistic Regression Learner< 1 %- SOTA Predictor< 1 %
- PCA Inversion< 1 %
Random Forest Learner< 1 %Tree Ensemble Learner< 1 %- Tree Ensemble Learner< 1 %
- Tree Ensemble Predictor (Regression)< 1 %
Random Forest Predictor< 1 %- Auto-Binner (Apply)< 1 %
Linear Correlation< 1 %- Filter Definition Merger< 1 %
- Nominal Probability Distribution Creator< 1 %
- Nominal Probability Distribution Splitter< 1 %
- Decision Tree to Ruleset< 1 %
- Cronbach Alpha< 1 %
Kaplan-Meier Estimator< 1 %- Friedman Test< 1 %
- Linear Discriminant Analysis< 1 %
- Linear Discriminant Analysis Inversion< 1 %
- Create Temp Dir (legacy)< 1 %
- PMML Compiling Predictor< 1 %
- Spark Joiner< 1 %
- Spark Pivot< 1 %
- SDF Stripper< 1 %
- Fingerprint Bayesian Learner< 1 %
- DB Connection Extractor< 1 %
- DB Row Filter< 1 %
DB Table Creator< 1 %- Gaussian Distributed Assigner< 1 %
- Quasirandom Sequence Generator (Apache)< 1 %
- TimeDelay Loop End< 1 %
- Time Series Generator< 1 %
- Bit Vector Distances< 1 %
- Java Distance< 1 %
- Distance Matrix Reader< 1 %
- K Nearest Neighbor (Distance Function)< 1 %
DL Network Executor< 1 %- DL Python Network Executor< 1 %
- Contour Plot (Plotly)< 1 %
- Error Bars Plot (Plotly)< 1 %
- Parallel Coordinates Plot (JavaScript)< 1 %
- Surface Plot (Plotly)< 1 %
- Boosting Learner Loop End< 1 %
- Table to PMML Ensemble< 1 %
- PMML Predictor< 1 %
- Prediction Fusion< 1 %
- Cell to PMML< 1 %
- Table to PDF (legacy)< 1 %
Table to PDF< 1 %- MoSS MCSS Molecule Similarity< 1 %
- Generic Web Service Client< 1 %
- DL4J Feedforward Learner (Classification) (legacy)< 1 %
- DL4J Feedforward Predictor (Classification) (legacy)< 1 %
- JPython Script 1:1 (Legacy)< 1 %
- Table Indexer< 1 %
- Rule Viewer (local) (Legacy)< 1 %
- OSM Map to Image< 1 %
XLS Writer< 1 %Excel Reader (XLS)< 1 %Open TIBCO Spotfire< 1 %Send to Tableau Server (Hyper)< 1 %Tableau Writer (Hyper)< 1 %Tableau Writer (TDE)< 1 %- Word2Vec Learner (legacy)< 1 %
- Frequency Filter< 1 %
- IDF< 1 %
- Topic Extractor (Parallel LDA)< 1 %
- Tika Language Detector< 1 %
- Dictionary Filter< 1 %
- Dictionary Replacer (File-based)< 1 %
- N Chars Filter< 1 %
Dictionary tagger< 1 %- Stanford Tagger< 1 %
Strings To Document< 1 %- Unique Term Extractor< 1 %
- External Tool (Labs)< 1 %
- Path to URI< 1 %
- GeoJSON writer< 1 %
Google Authenticator (API Key)< 1 %- JPMML Classifier< 1 %
- Credentials Configuration< 1 %
- Value Selection (legacy)< 1 %
Column Filter Widget< 1 %- Single Selection Widget< 1 %
- JSON Column Combiner< 1 %
- JSON Row Combiner< 1 %
- Container Input (Table)< 1 %
- Container Output (JSON)< 1 %
- JSON Diff< 1 %
- JSON to XML< 1 %
- Convolver< 1 %
- Labeling to String based Labeling< 1 %
- Labeling Properties< 1 %
- Align image< 1 %
- Image Converter< 1 %
- Maximum Finder< 1 %
- Apply Color Settings To Labels< 1 %
- Label Transformer< 1 %
- Don't Save Start< 1 %
- Image Calculator...< 1 %
- MongoDB Connector< 1 %
- Feature Inserter< 1 %
- Rowset Filter< 1 %
Python Script (1⇒1)< 1 %Python Edit Variable< 1 %- Python Learner (legacy)< 1 %
- Python Predictor (legacy)< 1 %
Python Script (2⇒2)< 1 %- Python Edit Variable (legacy)< 1 %
- PUT Request< 1 %
- Create Git Tag< 1 %
- Fail in execution< 1 %
- Duration to String< 1 %
- Time to String (legacy)< 1 %
XGBoost Linear Ensemble Learner (Regression)< 1 %XGBoost Tree Ensemble Learner (Regression)< 1 %- XML Row Combine and Write< 1 %
Table to HTML String< 1 %- Row Splitter (col+)< 1 %
Binary Scorer< 1 %- Molecule to CDK< 1 %
- SMARTS Query< 1 %
- RDKit Generate Coords< 1 %
- RDKit Molecule Catalog Filter< 1 %
- RDKit Molecule Extractor< 1 %
- RDKit Find Murcko Scaffolds< 1 %
- RDKit One Component Reaction< 1 %
- RDKit Optimize Geometry< 1 %
- RDKit To Molecule< 1 %
- RDKit Salt Stripper< 1 %
- RDKit Two Component Reaction< 1 %
- Hierarchical Anonymization< 1 %
- BERT Predictor< 1 %
- Neo4j Writer< 1 %
- Information Gain Calculator< 1 %
- Text Classifier Learner< 1 %
Location Extractor< 1 %MapzenGeocoder< 1 %- Geo Distances< 1 %
RMSE Calculator< 1 %- URL Domain Extractor< 1 %
HTTP Retriever< 1 %- HTML Parser< 1 %
Extract Outer/InnerHTML< 1 %
Views
- This node has no views
Workflows
Credit Scoring Model(diksha kumari)KNIME Hub- _01_PMR_AnalysisKNIME Hub
- _01_TestWF_Fails_Then_SucceedsKNIME Hub
- !Modern UI_ABC-XYX-RFM AutoML SuperstoreKNIME Hub
- (3D) Fragment library design workflowKNIME Hub
- Show all 6388 workflows
Links
- if X= A or B and Y <# then Rule engine node helpby s.roughley on 2018-04-11forum.knime.com/p/41397
- how to replace a blank cell from another columnby qqilihq on 2019-05-29forum.knime.com/p/61378
- How to use if then elseby qqilihq on 2019-06-17forum.knime.com/p/62333
- Converting integers to booleansby izaychik63 on 2018-12-17forum.knime.com/p/51608
- Duplicate rows with a specific multiplierby qqilihq on 2020-02-17forum.knime.com/p/81739
- Show all 54 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.