This node takes a list of user-defined rules and tries to match them
to each row in the input table. If the first matching rule has a
TRUE outcome, the row will be
selected for inclusion. Otherwise (i.e. if the first matching rule yields FALSE) it will be
excluded. If no rule matches the row will be excluded.
Inclusion and exclusion may be inverted, see the options below.
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 either
TRUE
or
FALSE
.
If no rule matches, the outcome is treated as if it were
FALSE
.
Columns are given by their name surrounded by $, numbers are given
in the usual decimal representation. Note that strings must not
contain (double-)quotes (for those cases use the following syntax: /Oscar Wilde's wisdom: "Experience is simply the name we give our mistakes."/). The flow variables are
represented by
$${
TypeCharacterAndFlowVarName
}$$
.
The TypeCharacter should be 'D' for double (real) values, 'I' for
integer values and 'S' for strings.
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 => TRUEWhen the values in Col0 are greater than 0, we select the row (if no previous rule matched with FALSE outcome).
$Col0$ = "Active" AND $Col1$ <= 5 => TRUEYou can combine conditions.
$Col0$ LIKE "Market Street*" AND
($Col1$ IN ("married", "divorced")
OR $Col2$ > 40) => FALSE
With parentheses you can combine multiple conditions.
$Col0$ MATCHES $${SFlowVar0}$$ OR $$ROWINDEX$$ < $${IFlowVar1}$$ =>
FALSE
The flow variables, table constants can also appear in conditions.
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
Popular Predecessors
- Rule-based Row Filter9 %
- GroupBy9 %
Row Filter (deprecated)7 %- Column Filter4 %
- Rule Engine4 %
- Math Formula3 %
- Excel Reader3 %
- Concatenate3 %
- String Manipulation3 %
- Duplicate Row Filter2 %
- CSV Reader2 %
- Column Expressions2 %
Column Rename2 %- Missing Value2 %
- String to Number1 %
- Sorter1 %
- Column Resorter1 %
- Rule-based Row Splitter1 %
- String to Date&Time1 %
- Rank1 %
- Value Counter1 %
- Nominal Value Row Filter1 %
- Date&Time Difference1 %
- Reference Row Filter< 1 %
- DB Query Reader< 1 %
- DB Reader< 1 %
- Loop End< 1 %
- Date&Time Part Extractor< 1 %
- Number to String< 1 %
- Date&Time-based Row Filter< 1 %
- Path to String< 1 %
- Table Reader< 1 %
- Cross Joiner< 1 %
- Table Row to Variable Loop Start< 1 %
Row Splitter (deprecated)< 1 %- Pivot< 1 %
- Constant Value Column< 1 %
- Cell Splitter< 1 %
- Column Renamer< 1 %
- File Reader< 1 %
- Table Manipulator< 1 %
Joiner< 1 %- Unpivot< 1 %
Excel Reader (XLS)< 1 %XLS Reader< 1 %- Date&Time to String< 1 %
- String Manipulation (Multi Column)< 1 %
- Table Creator< 1 %
- RowID< 1 %
- Column Aggregator< 1 %
- Java Snippet< 1 %
- Table Row to Variable< 1 %
- Case Converter< 1 %
- Date&Time Shift< 1 %
- Ungroup< 1 %
Database Reader< 1 %- Table Transposer< 1 %
- Math Formula (Multi Column)< 1 %
- Column Combiner< 1 %
- Column Merger< 1 %
- Number Rounder< 1 %
- List Files/Folders< 1 %
- Group Loop Start< 1 %
- Read Excel Sheet Names< 1 %
Cell Replacer< 1 %- String Manipulation (Variable)< 1 %
- Column Auto Type Cast< 1 %
- String Replacer< 1 %
- Parquet Reader< 1 %
- Excel Writer< 1 %
- Lag Column< 1 %
- IF Switch< 1 %
- Variable Creator< 1 %
- Legacy Date&Time to Date&Time< 1 %
- Modify Time< 1 %
- Column Appender< 1 %
- Nominal Value Row Splitter< 1 %
Excel Writer (XLS)< 1 %- File Reader (Complex Format)< 1 %
- Column Rename (Regex)< 1 %
- Counter Generation< 1 %
File Reader< 1 %Loop End< 1 %- Column Comparator< 1 %
- Column Renamer (Dictionary)< 1 %
- JSON Path< 1 %
- Variable Expressions< 1 %
- Python Script (legacy)< 1 %
- Date Field Extractor (legacy)< 1 %
- Value Lookup< 1 %
- Missing Value Column Filter< 1 %
- Reference Row Splitter< 1 %
- Linear Correlation< 1 %
- Empty Table Switch< 1 %
Variable to Table Row< 1 %Excel Writer (XLS)< 1 %- Merge Variables< 1 %
- CASE Switch Start< 1 %
- JSON to Table< 1 %
- Data Explorer< 1 %
- Date&Time Widget< 1 %
Line Reader< 1 %- Google Sheets Reader< 1 %
- Cell Splitter By Position< 1 %
- DB Writer< 1 %
- Date&Time Configuration< 1 %
- Modify Date< 1 %
- Math Formula (Variable)< 1 %
- String Configuration< 1 %
- Files/Folders Meta Info< 1 %
Database Looping< 1 %- Similarity Search< 1 %
- RDKit Descriptor Calculation< 1 %
- End IF< 1 %
- Row Filter (Labs)< 1 %
Random Forest Predictor< 1 %- Extract Missing Value Cause< 1 %
- Value Selection Widget< 1 %
- Column Splitter< 1 %
- DB Update< 1 %
- Table Difference Finder< 1 %
- DB Connection Closer< 1 %
- SharePoint Online List Reader< 1 %
- Chunk Loop Start< 1 %
- Statistics< 1 %
CSV Reader< 1 %- Auto-Binner< 1 %
- Java Snippet (simple)< 1 %
- Molecular Properties< 1 %
- Line Plot (Plotly)< 1 %
- URL to File Path< 1 %
- Rule-based Row Filter (Dictionary)< 1 %
- Molecule Type Cast< 1 %
- Twitter Search< 1 %
- Table Column to Variable< 1 %
- Column List Loop Start< 1 %
Tree Ensemble Predictor< 1 %Linear Correlation< 1 %String To Number (PMML)< 1 %- Crosstab< 1 %
- Date&Time to legacy Date&Time< 1 %
- TF< 1 %
Date Input (legacy)< 1 %- String to Date/Time (legacy)< 1 %
- String to Number (PMML)< 1 %
- Variable Loop End< 1 %
- Fuzzy c-Means< 1 %
- Normalizer< 1 %
Python Script (1⇒1)< 1 %Parquet Reader< 1 %- Recursive Loop Start< 1 %
- SDF Reader< 1 %
- Create Date&Time Range< 1 %
Excel Reader (XLS)< 1 %- Path to String (Variable)< 1 %
Regression Predictor< 1 %- Extract Table Spec< 1 %
- R Snippet< 1 %
- Rule Engine Variable< 1 %
CASE Switch Data (Start)< 1 %- Extract Table Dimension< 1 %
Recursive Loop End (2 ports)< 1 %- SAS7BDAT Reader< 1 %
Extract Date&Time Fields< 1 %- RDKit Substructure Filter< 1 %
- Single Selection Widget< 1 %
- Line Reader< 1 %
Parquet Reader< 1 %- Association Rule Learner< 1 %
- Partitioning< 1 %
- Row Sampling< 1 %
- Cache< 1 %
- Column Selection (legacy)< 1 %
- CSV Writer< 1 %
Table Row To Variable Loop Start< 1 %- Uniquify IDs< 1 %
Table Writer< 1 %- Table Validator< 1 %
- Numeric Outliers< 1 %
- Rank Correlation< 1 %
- CASE Switch End< 1 %
- String to Path< 1 %
- MzTabReader< 1 %
Document Data Extractor< 1 %- Value Selection (legacy)< 1 %
- Scatter Plot (JavaScript)< 1 %
- XPath< 1 %
- Top k Row Filter< 1 %
- Rule-based Row Splitter (Dictionary)< 1 %
- Single Selection Configuration< 1 %
Table Row To Variable Loop Start< 1 %Random Forest Learner< 1 %- Simple Regression Tree Predictor< 1 %
- Column Name Extractor< 1 %
- Mask Date/Time (legacy)< 1 %
- Text Output Widget (legacy)< 1 %
- Remove Empty Rows< 1 %
- Table Writer< 1 %
- Try (Data Ports)< 1 %
Logistic Regression Learner< 1 %- Parallel Chunk Start< 1 %
Excel Sheet Appender (XLS)< 1 %- Timer Info< 1 %
- Integer Configuration< 1 %
- Value Selection Configuration< 1 %
- String to Path (Variable)< 1 %
- JSON Writer< 1 %
- Speedy SMILES Ring Count< 1 %
Flow Variable End IF< 1 %- Split Collection Column< 1 %
- Extract URI Info< 1 %
- X-Aggregator< 1 %
Numeric Scorer< 1 %- Numeric Binner< 1 %
- Double to Integer< 1 %
- R to Table< 1 %
Hash Calculator< 1 %Database Writer< 1 %Number To String (PMML)< 1 %- Salesforce Simple Query< 1 %
- Substructure Match Counter< 1 %
- Create Collection Column< 1 %
- Gradient Boosted Trees Predictor (Regression)< 1 %
Concatenate (Optional in)< 1 %- Parallel Chunk End< 1 %
- OpenBabel< 1 %
- Association Rule Learner (Borgelt)< 1 %
Bag of Words Creator< 1 %- Date&Time Input (legacy)< 1 %
Gradient Boosted Trees Predictor< 1 %- Number to String (PMML)< 1 %
- Counting Loop Start< 1 %
- DB Query Extractor< 1 %
- Create File/Folder Variables< 1 %
- RDKit Find Murcko Scaffolds< 1 %
- Row Aggregator< 1 %
Table Column to Variable< 1 %- Fixed Width File Reader< 1 %
List Files< 1 %- Loop End (Column Append)< 1 %
- DBSCAN< 1 %
Gradient Boosted Trees Predictor< 1 %Column Appender< 1 %- Domain Calculator< 1 %
Double To Int< 1 %- Reference Column Splitter< 1 %
- Missing Value (Apply)< 1 %
- Random Number Assigner< 1 %
- Java Edit Variable (simple)< 1 %
- NGram Creator< 1 %
- Molecule to CDK< 1 %
Table Column to Variable< 1 %- Entropy Scorer< 1 %
- Spark to Table< 1 %
- Interactive Value Filter Widget< 1 %
- POST Request< 1 %
- Generic Loop Start< 1 %
- Row Splitter (Labs)< 1 %
- Fingerprint Similarity< 1 %
- ARIMA Predictor< 1 %
- Catch Errors (Data Ports)< 1 %
- Java Edit Variable< 1 %
- Feature Selection Loop Start (1:1)< 1 %
- Distance Matrix Pair Extractor< 1 %
- Filter Apply Row Splitter< 1 %
- Normalizer (Apply)< 1 %
- Denormalizer< 1 %
Read Excel Sheet Names (XLS)< 1 %- Double Input (legacy)< 1 %
Python Edit Variable< 1 %Integer Input (legacy)< 1 %- UNIX Timestamp to Date&Time< 1 %
- Time Difference (legacy)< 1 %
RDKit Structure Normalizer< 1 %Table Row to Variable< 1 %- Constant Value Column Filter< 1 %
- Joiner< 1 %
- String Widget< 1 %
SAP Reader (Theobald Software)< 1 %- Interactive Range Slider Filter Widget< 1 %
- Reaxys Substances< 1 %
- Regex Extractor< 1 %
- DB Looping< 1 %
- InChi< 1 %
Loop End (3 ports)< 1 %- Random Numbers Generator< 1 %
- Create Well Position< 1 %
Table Reader< 1 %Naive Bayes Predictor< 1 %K Nearest Neighbor< 1 %- Regression Predictor< 1 %
- Add Empty Rows< 1 %
Cell Splitter< 1 %- Category to Number< 1 %
- One to Many< 1 %
- Equal Size Sampling< 1 %
- Low Variance Filter< 1 %
- String Splitter (Regex)< 1 %
- Set Operator< 1 %
- Rule Engine (Dictionary)< 1 %
- Java Snippet Row Filter< 1 %
- Dictionary Filter< 1 %
- Value Filter (legacy)< 1 %
- Integer Input (legacy)< 1 %
- Table View (JavaScript)< 1 %
- String to JSON< 1 %
- R Source (Table)< 1 %
- Twitter Timeline< 1 %
- Substructure Search< 1 %
- Database List Tables (Legacy)< 1 %
Variable to Table Row< 1 %- One-way ANOVA< 1 %
DB Loader< 1 %- Boolean Configuration< 1 %
- Double Configuration< 1 %
- Regex Substring< 1 %
- Variable to Table Row< 1 %
- Subset Matcher< 1 %
- Delete Files/Folders< 1 %
- Nominal Row Filter Widget< 1 %
- Call Workflow (Table Based)< 1 %
- Table Row To Variable Run-for-time Loop Start< 1 %
- Advanced MolConverter< 1 %
- String to URI< 1 %
CSV Writer< 1 %Extract Context Properties< 1 %Counting Loop Start< 1 %Recursive Loop End< 1 %- Reference Column Filter< 1 %
- Numeric Row Splitter< 1 %
CASE Switch Data (End)< 1 %- Java IF (Table)< 1 %
- Tika Language Detector< 1 %
- Tag Filter< 1 %
Strings To Document< 1 %- Strings to Document< 1 %
- Google Analytics Query (legacy)< 1 %
- Moving Aggregator< 1 %
- RDKit To InChI< 1 %
- Extract System Properties< 1 %
- Parameterized DB Query Reader< 1 %
- Integer Widget< 1 %
- Table to JSON< 1 %
- Modify Time Zone< 1 %
- Fingerprints< 1 %
- CIR< 1 %
- Scorer< 1 %
- Scatter Plot (Plotly)< 1 %
- Workflow Service Input< 1 %
- Row to Column Names< 1 %
Loop End (Upto 6 ports)< 1 %- Wait...< 1 %
Table Row to Variable< 1 %Interval Loop Start< 1 %Recursive Loop Start< 1 %- k-Means< 1 %
- Logistic Regression Predictor< 1 %
- Table Validator (Reference)< 1 %
String Replace (Dictionary)< 1 %- Data Generator< 1 %
K Nearest Neighbor (Distance Function)< 1 %- DL4J Feedforward Predictor (Classification) (legacy)< 1 %
- Item Set Finder (Borgelt)< 1 %
- Term Co-Occurrence Counter< 1 %
- String Matcher< 1 %
- Table Editor (JavaScript)< 1 %
- Parameter Optimization Loop Start< 1 %
- Time Field Extractor (legacy)< 1 %
- Standardizer< 1 %
- Catch Errors (Var Ports)< 1 %
Simple File Reader< 1 %- K Nearest Neighbor< 1 %
- Logistic Regression Learner< 1 %
- PCA< 1 %
- Gradient Boosted Trees Predictor< 1 %
- Ruleset to Table< 1 %
- Nominal Row Filter Configuration< 1 %
- Double Widget< 1 %
- Container Input (Table)< 1 %
- String to XML< 1 %
- Interval Loop Start< 1 %
Call Workflow Service< 1 %- Extract Context Properties< 1 %
- Hash Calculator< 1 %
- String Replacer (Dictionary)< 1 %
- Table Splitter< 1 %
- Canonical SMILES< 1 %
- TIBCO Spotfire File Reader< 1 %
- Outlier Removal< 1 %
- MolConverter< 1 %
- Fingerprint Similarity< 1 %
- Copy/Move Files (legacy)< 1 %
- List Remote Files (legacy)< 1 %
- URI to String< 1 %
- Extract Variables (Data)< 1 %
- Inject Variables (Data)< 1 %
Database Update< 1 %Loop End (2 ports)< 1 %Variable Condition Loop End< 1 %Generic Loop Start< 1 %- Decision Tree Predictor< 1 %
- MultiLayerPerceptron Predictor< 1 %
PCA< 1 %- Linear Regression Learner< 1 %
Scorer< 1 %- Random Forest Predictor< 1 %
String To Number< 1 %- Filter Apply< 1 %
- Reference Column Resorter< 1 %
- Shuffle< 1 %
Rank Correlation< 1 %- Independent groups t-test< 1 %
CASE Switch Variable (End)< 1 %CASE Switch Variable (Start)< 1 %- Send Email< 1 %
- Conditional Box Plot (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Color Manager< 1 %
- Molfile Reader< 1 %
- Prediction Fusion< 1 %
- H2O to Table< 1 %
Excel Reader (XLS)< 1 %- DF< 1 %
- Case Converter< 1 %
- Snowball Stemmer< 1 %
- Tika Parser< 1 %
- Bag Of Words Creator< 1 %
- Document Data Extractor< 1 %
- Sentence Extractor< 1 %
- Tags to String< 1 %
- Term to String< 1 %
- Weka Predictor (3.7)< 1 %
- Column Filter (legacy)< 1 %
- String Input (legacy)< 1 %
- Feature Calculator (BETA)< 1 %
Python Script (1⇒1)< 1 %- Python Source (legacy)< 1 %
- Python Edit Variable (legacy)< 1 %
- R Predictor< 1 %
- R Snippet< 1 %
- Table to R< 1 %
- GET Request< 1 %
- Date/Time Shift (legacy)< 1 %
- Moving Average< 1 %
- Time to String (legacy)< 1 %
- Lipinski's Rule-of-Five< 1 %
- XLogP< 1 %
- Fingerprint Similarity< 1 %
- RDKit Canon SMILES< 1 %
- RDKit From Molecule< 1 %
- RDKit Molecule Substructure Filter< 1 %
- RDKit Optimize Geometry< 1 %
- RDKit To Molecule< 1 %
- RDKit Substructure Counter< 1 %
- Latitude/Longitude to Coordinate< 1 %
- String Similarity< 1 %
- URL Extractor< 1 %
- HTTP Retriever< 1 %
- HTML Parser< 1 %
- Molecule Properties< 1 %
- Get Users< 1 %
- Collection to String< 1 %
- Normalize Plates (Z-Score)< 1 %
- Spell Checker: Create Rules< 1 %
- Binary Objects to PNGs< 1 %
- Breakpoint< 1 %
- Active Branch Inverter< 1 %
Variable to Table Column< 1 %- Create File Name (legacy)< 1 %
Table Column to Variable< 1 %- Naive Bayes Predictor< 1 %
- Silhouette Coefficient< 1 %
- Hierarchical Cluster Assigner (local)< 1 %
- Numeric Scorer< 1 %
- SVM Predictor< 1 %
- Column to Grid< 1 %
- ROC Curve (legacy)< 1 %
- Interactive Table (legacy)< 1 %
- DB Delete (Table)< 1 %
- DB Column Filter< 1 %
- Index Query< 1 %
- PDF Parser< 1 %
- Column Filter Configuration< 1 %
- Integer Slider Configuration< 1 %
- Column Selection Configuration< 1 %
- Line Plot (JavaScript)< 1 %
- Tag Cloud (JavaScript)< 1 %
- Slider Widget< 1 %
- DELETE Request< 1 %
- Duration to Number< 1 %
- RDKit Interactive Table< 1 %
- RDKit Salt Stripper< 1 %
Regex Extractor< 1 %Column Distance< 1 %- HTTP Result Data Extractor< 1 %
- Indigo Fingerprint< 1 %
- Coordinate Row Filter< 1 %
- Upload (legacy)< 1 %
- Variable to Table Column< 1 %
- Variable Condition Loop End< 1 %
- Recursive Loop End< 1 %
- DB Insert< 1 %
- DB SQL Executor< 1 %
- Delete Files/Folders (Table)< 1 %
- Multiple Selection Configuration< 1 %
- Column Filter Widget< 1 %
- Refresh Button Widget< 1 %
- Multiple Selection Widget< 1 %
- Benchmark End< 1 %
- PATCH Request< 1 %
- Violin Plot (Plotly)< 1 %
Google Authenticator (Deprecated)< 1 %- Workflow Service Output< 1 %
- Configurable IF/CASE Switch (Flow Variable Value)< 1 %
- Table Updater< 1 %
- Tika Parser URL Input< 1 %
- Google Analytics Query< 1 %
- ORC Reader< 1 %
- Boolean Widget< 1 %
- List Box Widget< 1 %
- Don't Save Start< 1 %
- Run Garbage Collector< 1 %
- Speedy SMILES Heavy Atom Count (HAC)< 1 %
IF Switch (Flow Variable Value)< 1 %- Number Formatter< 1 %
- Pareto Ranking< 1 %
Recursive Loop Start (2 ports)< 1 %Tree Ensemble Learner< 1 %- Tree Ensemble Predictor< 1 %
Color Appender< 1 %- Shape Manager< 1 %
- JPython Script 1:1 (Legacy)< 1 %
- Number Filter< 1 %
- Network Analyzer< 1 %
String Input (legacy)< 1 %- Twitter Retweet Search< 1 %
- MMP Molecule Fragment (RDKit)< 1 %
- Create Bit Vector< 1 %
- Normalizer (PMML)< 1 %
- Autocomplete Text Widget< 1 %
Excel Sheet Appender (XLS)< 1 %JSON Reader< 1 %- Don't Save End< 1 %
- XGBoost Predictor< 1 %
- Reaction Splitter< 1 %
- Domain - Leverage< 1 %
- Fingerprint AND< 1 %
- Feature Selection Loop End< 1 %
- Hierarchical Cluster Assigner< 1 %
- Auto-Binner (Apply)< 1 %
- Decompress Files< 1 %
- String to Duration< 1 %
- Web Page Content Extractor< 1 %
Table Extractor< 1 %IF Switch (Flow Variable Value)< 1 %- Shapefile Polygon Reader< 1 %
- Range Filter< 1 %
- R Snippet (2:1)< 1 %
File Meta Info< 1 %Database Connection Table Reader< 1 %- PNN Predictor< 1 %
PCA Apply< 1 %PMML Gradient Boosted Trees Predictor< 1 %- Binner (Dictionary)< 1 %
- Create Table Structure< 1 %
- Edit Nominal Domain< 1 %
- HiLite Row Splitter< 1 %
- Numeric Binner (PMML)< 1 %
- Ruleset Editor< 1 %
- Scatter Plot (legacy)< 1 %
SAS7BDAT Reader< 1 %Python Script (2⇒1)< 1 %- Window Loop Start< 1 %
Extract Outer/InnerHTML< 1 %- Quit WebDriver< 1 %
Read MDB< 1 %- Substructure Matcher< 1 %
Flow Variable IF Switch< 1 %- Table Row To Variable Run-to-time Loop Start< 1 %
- Read Variables< 1 %
- Fragments to MMPs< 1 %
- Chemical Terms< 1 %
- Category to Number (Apply)< 1 %
- Denormalizer (PMML)< 1 %
- Wilcoxon-Mann-Whitney Test< 1 %
ORC Reader< 1 %- K Nearest Neighbor (Distance Function)< 1 %
- Flat File Document Parser< 1 %
- Boolean Input (legacy)< 1 %
- Data Row to Image< 1 %
- Image Properties< 1 %
- XGBoost Predictor (Regression)< 1 %
- Expand Well Position< 1 %
- Capture Workflow Start< 1 %
- Path to URI< 1 %
- JSON Row Combiner< 1 %
- Container Input (JSON)< 1 %
- Atom Signatures< 1 %
- Standard Properties< 1 %
PMI Calculation< 1 %- List Folders< 1 %
- Plate Heatmap Viewer< 1 %
- IDTextReader< 1 %
- Naming< 1 %
- File Meta Info (legacy)< 1 %
- Tree Ensemble Predictor (Regression)< 1 %
- Expand Bit Vector< 1 %
- Correlation Filter< 1 %
- Decision Tree to Ruleset< 1 %
- Random Matcher< 1 %
- Geo-Coordinate Row Filter< 1 %
- Radar Plot Appender< 1 %
Vocabulary Extractor (legacy)< 1 %- Topic Extractor (Parallel LDA)< 1 %
- Word Parser< 1 %
- String to Term< 1 %
- Weka Cluster Assigner (3.7)< 1 %
- Image Output (legacy)< 1 %
- List Box Input (legacy)< 1 %
- Image Cropper< 1 %
- Feature Table< 1 %
- Node Table< 1 %
Python Source< 1 %Value Selection QuickForm (legacy)< 1 %- Disturber Node< 1 %
- Time Generator (legacy)< 1 %
- Preset Date/Time (legacy)< 1 %
- Country Extractor< 1 %
XML Reader< 1 %- CDK to Molecule< 1 %
- Element Filter< 1 %
- RDKit From InChI< 1 %
- RDKit Kekulizer< 1 %
- List to FlowVariable< 1 %
- Molecule Properties< 1 %
- Feature Remover< 1 %
- Murcko Scaffold< 1 %
- Fingerprint INTERSECTS< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %- Chunk Loop Run-for-time Loop Start< 1 %
- Collection Size< 1 %
- Shapefile Point Reader< 1 %
- Normalize Plates (NPI)< 1 %
- logP< 1 %
- Automated Matched Pairs< 1 %
- SMOTE< 1 %
- Bootstrap Sampling< 1 %
- Edit Numeric Domain< 1 %
- Renderer to Image< 1 %
- Rule Engine Variable (Dictionary)< 1 %
- Single sample t-test< 1 %
- Line Plot (legacy)< 1 %
- Amazon Comprehend (Dominant Language)< 1 %
- Random Boolean Assigner< 1 %
- Random Number Assigner (Apache)< 1 %
Read XLS Sheet Names< 1 %- Diacritic Remover< 1 %
- RegEx Filter< 1 %
- Stanford Lemmatizer< 1 %
- Tile View (JavaScript)< 1 %
- Column Selection Widget< 1 %
- Container Output (Table)< 1 %
- Columns to JSON< 1 %
- Duration to String< 1 %
- Extract Duration Fields< 1 %
- RDKit Fingerprint< 1 %
- RDKit R-Group Decomposition< 1 %
- Find Elements< 1 %
- Standardizer< 1 %
Database Delete< 1 %- JSON Schema Validator< 1 %
- RDKit Molecule Catalog Filter< 1 %
- Anonymization< 1 %
- Reaxys Bioactivities< 1 %
Flow Variable IF Switch (Flow Variable Value)< 1 %Fragments to MMPs< 1 %PDB Connector< 1 %- ConsensusTextReader< 1 %
- MolImporter< 1 %
- Create Directory (legacy)< 1 %
- Unzip Files (legacy)< 1 %
- URL to File Path (Variable)< 1 %
Variable to Table Column< 1 %- Read Images< 1 %
- ARFF Reader< 1 %
SQL Extract< 1 %Parameterized Database Query< 1 %Variable Loop End< 1 %- X-Partitioner< 1 %
- Fuzzy Rule Predictor< 1 %
- Cluster Assigner< 1 %
- Hierarchical Clustering< 1 %
PCA Compute< 1 %Random Forest Learner< 1 %- Random Forest Learner< 1 %
- Random Forest Predictor (Regression)< 1 %
- Perl Scripting< 1 %
- Expand Byte Vector< 1 %
- Number to Category (Apply)< 1 %
Number To String< 1 %- Interactive HiLite Collector< 1 %
- Column Filter (PMML)< 1 %
- Target Shuffling< 1 %
- Ruleset Predictor< 1 %
- Create Temp Dir (legacy)< 1 %
Merge Variables< 1 %- Save Workflow< 1 %
- Stresser< 1 %
- TimeDelay Loop End< 1 %
- Distance Matrix Calculate< 1 %
- Sunburst Chart (JavaScript)< 1 %
- Voting Loop End< 1 %
- MoSS< 1 %
- External Tool< 1 %
XLS Writer< 1 %- Java Snippet Row Splitter< 1 %
- Vocabulary Extractor (legacy)< 1 %
- Chi-Square Keyword Extractor< 1 %
- Keygraph Keyword Extractor< 1 %
- Kuhlen Stemmer< 1 %
Stop Word Filter< 1 %- Stop Word Filter< 1 %
- Document Data Assigner< 1 %
- Credentials Input (legacy)< 1 %
- Slider Input (legacy)< 1 %
- Multiple Selections (legacy)< 1 %
- Single Selection (legacy)< 1 %
Simple Table View (JavaScript)< 1 %- Max Filter< 1 %
Python Script (2⇒1)< 1 %- SPARQL Query< 1 %
- Extract Time Window (legacy)< 1 %
- Information Gain Calculator< 1 %
- Text Classifier Predictor< 1 %
Location Extractor< 1 %- XLS Control Table Generator< 1 %
- R-Group Decomposer< 1 %
- Duplicate Remover< 1 %
- Principal Moment of Intertia (PMI)-Derived Properties< 1 %
- Speedy SMILES Charge Count< 1 %
- Speedy SMILES Possible Stereoisomer Count< 1 %
- Speedy SMILES Element Count (C, N, O)< 1 %
- Fingerprint From Set Bits list< 1 %
- Fingerprint OR< 1 %
Loop End (Upto 4 ports)< 1 %- Benchmark Start< 1 %
- Benchmark Start (Memory Monitoring)< 1 %
- Missing to Empty Collection< 1 %
- PDB Sequence Extractor< 1 %
PDB Connector< 1 %- Combine Columns by Header< 1 %
- BinningAnalysis< 1 %
- Normalize Plates (POC)< 1 %
- Vector Length Normalization< 1 %
- Bemis-Murcko< 1 %
- Elemental Analysis< 1 %
- H Bond Donor/Acceptor< 1 %
- Molecular Dynamics< 1 %
- Binary Objects to Strings< 1 %
- Delete Files (legacy)< 1 %
- Download (legacy)< 1 %
- Port to URI< 1 %
- Strings to Binary Objects< 1 %
- Try (Variable Ports)< 1 %
Database SQL Executor< 1 %Line Reader< 1 %- Feature Selection Loop Start (2:2)< 1 %
- Fuzzy Rule Learner< 1 %
- SOTA Predictor< 1 %
- PCA Apply< 1 %
Random Forest Predictor (Regression)< 1 %PMML Gradient Boosted Trees Predictor< 1 %- Random Forest Learner (Regression)< 1 %
- Tree Ensemble Statistics< 1 %
- Edit Nominal Domain (Dictionary)< 1 %
- One to Many (PMML)< 1 %
- Normalizer Apply (PMML)< 1 %
- Numeric Outliers (Apply)< 1 %
- Shapiro-Wilk Test< 1 %
- Global Timer Info< 1 %
- Extract Color< 1 %
- SDF Extractor< 1 %
- Amazon DynamoDB Scan< 1 %
- Parallel Chunk End (multi port)< 1 %
- DB Merge< 1 %
- Empty Table Creator< 1 %
- TimeDelay Loop Start< 1 %
- Mahalanobis Distance< 1 %
- k-Medoids< 1 %
PMML Ensemble Predictor< 1 %- PMML Predictor< 1 %
- MoSS MCSS Molecule Similarity< 1 %
- DL4J Feedforward Predictor (Layer) (legacy)< 1 %
- DL4J Feedforward Predictor (Regression) (legacy)< 1 %
- H2O Generalized Linear Model Learner (Regression)< 1 %
- Ruby Script< 1 %
- Term Document Entropy< 1 %
- IDF< 1 %
- Category to Class< 1 %
- Markup Tag Filter< 1 %
- N Chars Filter< 1 %
- Modifiable Term Filter< 1 %
- Porter Stemmer< 1 %
- Punctuation Erasure< 1 %
- Replacer< 1 %
- Tag Stripper< 1 %
Dictionary tagger< 1 %Wildcard tagger< 1 %- Term Neighborhood Extractor< 1 %
- t-SNE (L. Jonsson)< 1 %
- GeoJSON reader< 1 %
- Shapefile reader< 1 %
- Value Filter Definition (legacy)< 1 %
- File Chooser (legacy)< 1 %
- ROC Curve (JavaScript)< 1 %
Container Input (Variable)< 1 %- XML to JSON< 1 %
- PNG Image to ImgPlus< 1 %
MongoDB Reader< 1 %Python Script (1⇒2)< 1 %Python Script (1⇒2)< 1 %Python Script (2⇒2)< 1 %- PUT Request< 1 %
- Webpage Retriever< 1 %
- Triple File Reader< 1 %
- Twitter Users< 1 %
- Web Log Reader< 1 %
Dumb Joiner< 1 %- 3D WHIM< 1 %
- Date Extractor< 1 %
Reverse Location Lookup< 1 %- TF-IDF Similarity< 1 %
- Feed Discovery< 1 %
FreeGeoIP< 1 %- Current URL< 1 %
- Duplicate Filter< 1 %
- ChEMBL-DB Extractor< 1 %
- Correlation Matrix To Pairs< 1 %
- TIBCO Spotfire Information Link Reader< 1 %
- Fingerprint to String< 1 %
- Is Empty< 1 %
- Total Count< 1 %
- Load SD-Files (SDF)< 1 %
- Load Text Files< 1 %
- Benchmark End (Memory Monitoring)< 1 %
- Set To List< 1 %
- PDB Saver< 1 %
- Extract Column Properties< 1 %
- Binning Apply< 1 %
- Python Snippet< 1 %
- JChem External Tool 0:1< 1 %
- Similarity Calculator< 1 %
- Structure Checker< 1 %
- Desirability Ranking< 1 %
- Variable to Credentials< 1 %
- Feature Selection Filter< 1 %
- Decision Tree Learner< 1 %
- Filter Definition Merger< 1 %
- HiLite Table (legacy)< 1 %
- Amazon S3 File Picker (legacy)< 1 %
- DB Table Creator< 1 %
- One Row to Many< 1 %
- Create Folder< 1 %
- Create Temp Folder< 1 %
- List Box Configuration< 1 %
- Container Input (Variable)< 1 %
- Global Thresholder< 1 %
RDKit Functional Group Filter< 1 %- RDKit Molecule Fragmenter< 1 %
Click< 1 %
Views
- This node has no views
Workflows
_01_PMR_AnalysisKNIME Hub- (Optional)_Linear_RegressionKNIME Hub
- [01.CX] Combining Siloed Legacy Data with Running App's Back-End DatabaseKNIME Hub
- [03.CX] Extracting and Transforming Viber Broadcast Data from InfobipKNIME Hub
- 0. Lubes_Sales_Pred-ModelNodePit Space
- Show all 2476 workflows
Links
- Delete Rowby qqilihq on 2018-06-01forum.knime.com/p/43552
- Filter blank rows outby izaychik63 on 2019-02-14forum.knime.com/p/54508
- Removing rows which contains less than or equal to three wordsby armingrudd on 2019-09-03forum.knime.com/p/69158
- Selection of Product using various rulesby izaychik63 on 2020-04-15forum.knime.com/p/87652
- Find similar rowsby armingrudd on 2018-12-25forum.knime.com/p/52077
- Show all 22 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.