This node takes each row in the query table (Port 0) and searches the reference table (Port 1) for a number of rows matching the specified similarity/distance criteria. If multiple results are requested, the query result row is duplicated for each subsequent match.
Options
Popular Successors
- Joiner10 %
- Column Filter5 %
Row Filter (deprecated)4 %- Rule-based Row Filter3 %
Scorer2 %- Numeric Binner1 %
- Variable to Table Column1 %
- GroupBy1 %
- Sorter1 %
- Document Data Extractor1 %
Table Row To Variable Loop Start1 %- CSV Writer1 %
- Loop End1 %
- Java Snippet< 1 %
XLS Writer< 1 %- Catch Errors (Data Ports)< 1 %
Joiner< 1 %- Interactive Histogram (legacy)< 1 %
- Excel Writer< 1 %
- Object Inserter< 1 %
- Hierarchical Clustering (DistMatrix)< 1 %
Column Appender< 1 %- Rule Engine< 1 %
- HeatMap (JFreeChart)< 1 %
- Histogram Chart (JFreeChart)< 1 %
- Scatter Plot (JFreeChart)< 1 %
- Term to String< 1 %
- Latitude/Longitude to Coordinate< 1 %
- Fingerprint Similarity< 1 %
Table Row to Variable< 1 %K Nearest Neighbor< 1 %Row Splitter (deprecated)< 1 %- Table Manipulator< 1 %
- Line Plot (legacy)< 1 %
- String Distances< 1 %
- Table to H2O< 1 %
Loop End< 1 %- K Nearest Neighbor< 1 %
PCA< 1 %- Auto-Binner< 1 %
- Create Bit Vector< 1 %
- Column Combiner< 1 %
- Lag Column< 1 %
- Column Resorter< 1 %
- Pivot< 1 %
- Top k Row Filter< 1 %
- Document Vector< 1 %
- Table View (JavaScript)< 1 %
- RDKit Interactive Table< 1 %
- Group Loop Start< 1 %
- Fuzzy Rule Learner< 1 %
- Distance Matrix Pair Extractor< 1 %
- Column Aggregator< 1 %
- Constant Value Column< 1 %
- String Manipulation< 1 %
- Interactive Table (legacy)< 1 %
- Molecule Type Cast< 1 %
- Distance Matrix Calculate< 1 %
K Nearest Neighbor (Distance Function)< 1 %- K Nearest Neighbor (Distance Function)< 1 %
- Similarity Search< 1 %
- Math Formula< 1 %
- Document Viewer< 1 %
- Scatter Plot (JavaScript)< 1 %
- String Similarity< 1 %
- Recursive Loop End< 1 %
- k-Means< 1 %
- Polynomial Regression Learner< 1 %
- Concatenate< 1 %
Cell Replacer< 1 %Number To String< 1 %- Number to String< 1 %
- Duplicate Row Filter< 1 %
- HiLite Row Splitter< 1 %
- Nominal Value Row Filter< 1 %
- Reference Row Filter< 1 %
- Denormalizer< 1 %
- Normalizer< 1 %
Column Rename< 1 %- Column Splitter< 1 %
- String Replacer (Dictionary)< 1 %
- Table Transposer< 1 %
- Value Lookup< 1 %
- Rule-based Row Splitter< 1 %
- Statistics< 1 %
- Color Manager< 1 %
- Scatter Plot< 1 %
- Numeric Distances< 1 %
- Column Expressions< 1 %
- Math Formula (Multi Column)< 1 %
- Java Snippet (simple)< 1 %
- Category to Class< 1 %
- Heatmap (JavaScript)< 1 %
- RDKit Descriptor Calculation< 1 %
- RDKit From Molecule< 1 %
- RDKit Fingerprint< 1 %
- Hierarchical Cluster Assigner (local)< 1 %
Concatenate (Optional in)< 1 %Cell Splitter< 1 %String To Number< 1 %- Row Filter (Labs)< 1 %
- Missing Value (Apply)< 1 %
- RowID< 1 %
- Row Sampling< 1 %
- Conditional Box Plot (legacy)< 1 %
- SDF Writer< 1 %
- Parallel Chunk End< 1 %
- Bit Vector Distances< 1 %
- Java Distance< 1 %
- Mahalanobis Distance< 1 %
- Matrix Distance< 1 %
- Distance Matrix Writer< 1 %
- k-Medoids< 1 %
- IDF< 1 %
- TF< 1 %
- Punctuation Erasure< 1 %
- Sentence Extractor< 1 %
- Distance Matrix to Network< 1 %
Loop End (3 ports)< 1 %- Vector Distance (n-D)< 1 %
- MarvinView< 1 %
- Tree Ensemble Learner< 1 %
- String to Number< 1 %
- Cross Joiner< 1 %
- Reference Row Splitter< 1 %
- Ungroup< 1 %
- Numeric Outliers< 1 %
- Scatter Plot (legacy)< 1 %
- Counter Generation< 1 %
- OSM Map View< 1 %
- Fingerprints< 1 %
- RDKit To InChI< 1 %
- Create Collection Column< 1 %
Variable to Table Column< 1 %- Chunk Loop Start< 1 %
Recursive Loop Start< 1 %- Fuzzy c-Means< 1 %
- MDS< 1 %
Numeric Scorer< 1 %- SVM Learner< 1 %
- Expand Bit Vector< 1 %
- Column Rename (Regex)< 1 %
- Missing Value Column Filter< 1 %
- Rank< 1 %
- String Splitter (Regex)< 1 %
- Unpivot< 1 %
- Renderer to Image< 1 %
Rule Engine< 1 %- One-way ANOVA< 1 %
- Extract Table Dimension< 1 %
- Lift Chart (legacy)< 1 %
Excel Sheet Appender (XLS)< 1 %Excel Writer (XLS)< 1 %- Java Snippet Row Splitter< 1 %
- String Matcher< 1 %
- Bag Of Words Creator< 1 %
- Column Filter (legacy)< 1 %
- ROC Curve (JavaScript)< 1 %
- Matrix to Network< 1 %
- Parameter Optimization Loop End< 1 %
- R Snippet< 1 %
- Date&Time to String< 1 %
- 2D Coordinates< 1 %
- TF-IDF Similarity< 1 %
- CIR< 1 %
- Fingerprint Similarity Calculator< 1 %
- Distance (1-D)< 1 %
- Plate Heatmap Viewer< 1 %
- Similarity Calculator< 1 %
- Fingerprints Expander< 1 %
- Split Collection Column< 1 %
- File Meta Info (legacy)< 1 %
Variable to Table Column< 1 %CSV Writer< 1 %Database Writer< 1 %Table Writer< 1 %- Feature Selection Loop Start (1:1)< 1 %
- Loop End (Column Append)< 1 %
Recursive Loop End< 1 %- Table Row to Variable Loop Start< 1 %
- X-Aggregator< 1 %
- Naive Bayes Learner< 1 %
- Cluster Assigner< 1 %
- Silhouette Coefficient< 1 %
- Hierarchical Clustering< 1 %
- Hierarchical Cluster Assigner< 1 %
- Hierarchical Cluster View< 1 %
- DBSCAN< 1 %
- Decision Tree Learner< 1 %
- MDS Projection (DistMatrix)< 1 %
- Scorer< 1 %
- PCA< 1 %
- Cell Splitter< 1 %
- Column Comparator< 1 %
- Column Merger< 1 %
- Many to One< 1 %
- One to Many< 1 %
- Linear Correlation< 1 %
- Double to Integer< 1 %
- Reference Column Filter< 1 %
- Interactive HiLite Collector< 1 %
- Subset Matcher< 1 %
- Normalizer (Apply)< 1 %
- Partitioning< 1 %
- Column Filter (PMML)< 1 %
- Missing Value< 1 %
- Numeric Row Splitter< 1 %
- Shuffle< 1 %
- String Manipulation (Multi Column)< 1 %
- String Replacer< 1 %
- Value Counter< 1 %
Rank Correlation< 1 %- Independent groups t-test< 1 %
- End IF< 1 %
- IF Switch< 1 %
- Crosstab< 1 %
- Histogram (legacy)< 1 %
- Pie chart (legacy)< 1 %
- Box Plot (legacy)< 1 %
- Parallel Coordinates (legacy)< 1 %
- Scatter Matrix (legacy)< 1 %
Color Appender< 1 %- ROC Curve (legacy)< 1 %
- Smiles Directory Writer< 1 %
DB Table Creator< 1 %- Histogram (JavaScript)< 1 %
- Universe Marker< 1 %
Table to PDF< 1 %- MoSS MCSS Molecule Similarity< 1 %
- Math Formula (Variable)< 1 %
- Line Chart (JFreeChart)< 1 %
- Pie Chart (JFreeChart)< 1 %
- Bubble Chart (JFreeChart)< 1 %
- Table Indexer< 1 %
Excel Writer (XLS)< 1 %Excel Sheet Appender (XLS)< 1 %Send to Tableau Server (TDE)< 1 %- Frequency Filter< 1 %
- Brat Document Writer< 1 %
- Dictionary Tagger< 1 %
Document Data Extractor< 1 %Strings To Document< 1 %- Strings to Document< 1 %
- Term Neighborhood Extractor< 1 %
Document Viewer< 1 %- Table Editor (JavaScript)< 1 %
- Tag Cloud (JavaScript)< 1 %
- Labeling Properties< 1 %
- Distance Map< 1 %
Python Script (1⇒1)< 1 %- Time Difference (legacy)< 1 %
- Moving Aggregator< 1 %
- Molecule to CDK< 1 %
- 3D D-Similarity< 1 %
- Fingerprint Similarity< 1 %
- RDKit Diversity Picker< 1 %
- RDKit One Component Reaction< 1 %
- RDKit Substructure Filter< 1 %
- RDKit Substructure Counter< 1 %
- Text Classifier Learner< 1 %
Map Viewer< 1 %Column Distance< 1 %
Views
- This node has no views
Workflows
(3D) Fragment library design workflowKNIME Hub- 00_SetupKNIME Hub
- 00_SetupKNIME Hub
- 00_SetupKNIME Hub
- 00_SetupKNIME Hub
- Show all 354 workflows
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.