Enables the definition of arbitrary distance measures using a Java snippet. A distance measure is
defined on two equal structured rows. You can refer to a cell value by enclosing the column name
prefixed by either
row1
or
row2
for example
$row1.c1$
.
Compute the Euclidean distance of the columns
c1
and
c2
:
sqrt(sqr($row1.c1$-$row2.c1$)+sqr($row1.c2$-$row2.c2$))
Compute the arithmetic mean of the Levenshtein distance of the columns
c1
and
c2
:
mean(levenshtein($row1.c0$,$row2.c0$),levenshtein($row1.c1$, $row2.c1$))
Note that strings which are part of the expression and are not from the input data (or the result of another wrapped function call) need to be enclosed in double quotes ('"'). Additionally, if the string contains a quote character, it must be escaped using a backslash character ('\"'). Finally, other special characters such as single quotes and backslashes need to be escaped using a backslash. For instance, a single backslash in a string is written as two consecutive backslash characters; the first one acts as the escape character for the second.
Options
Popular Predecessors
- Java Snippet (simple)7 %
CSV Reader6 %- Table Creator5 %
- GroupBy5 %
File Reader4 %- ARFF Reader4 %
- Cross Joiner4 %
Column Rename4 %- Column Filter4 %
Row Filter (deprecated)3 %- Create Collection Column2 %
- Java Snippet2 %
- Normalizer2 %
- Create Bit Vector2 %
- Cell Splitter2 %
- Table Manipulator2 %
- Joiner2 %
Scorer2 %- Similarity Search2 %
- Random Number Assigner2 %
Excel Reader (XLS)2 %- Row Sampling1 %
Python Script (1⇒1)1 %- Sorter1 %
- Benchmark End< 1 %
- X-Aggregator< 1 %
Row Splitter (deprecated)< 1 %- String Manipulation< 1 %
- k-Medoids< 1 %
- Group Loop Start< 1 %
- Distance Matrix Pair Extractor< 1 %
- Lag Column< 1 %
- Missing Value< 1 %
- Rule-based Row Filter< 1 %
- Color Manager< 1 %
- Math Formula (Variable)< 1 %
Excel Reader (XLS)< 1 %- Tile View (JavaScript)< 1 %
- Split Collection Column< 1 %
Table Row to Variable< 1 %- Chunk Loop Start< 1 %
- Concatenate< 1 %
- Column Auto Type Cast< 1 %
Joiner< 1 %- Data Generator< 1 %
- String to Date/Time (legacy)< 1 %
Database Reader< 1 %Counting Loop Start< 1 %Recursive Loop End< 1 %- Hierarchical Clustering< 1 %
- DBSCAN< 1 %
- Numeric Binner< 1 %
- Category to Number< 1 %
Number To String< 1 %- Column Rename (Regex)< 1 %
- Column Splitter< 1 %
- Statistics< 1 %
CASE Switch Data (Start)< 1 %- Cache< 1 %
- Crosstab< 1 %
- Shape Manager< 1 %
- Mahalanobis Distance< 1 %
- Distance Matrix Reader< 1 %
K Nearest Neighbor (Distance Function)< 1 %- K Nearest Neighbor (Distance Function)< 1 %
- Decision Tree View (JavaScript)< 1 %
Python Script (2⇒1)< 1 %Table Reader< 1 %- Row Filter (Labs)< 1 %
- Rule Engine< 1 %
- Column Expressions< 1 %
- Math Formula< 1 %
- Excel Reader< 1 %
- Scorer (JavaScript)< 1 %
Views
- This node has no views
Workflows
20220307 Pikairos Similarity Search Return all matches within a rangeKNIME Forum- CI_IA_Bank reconciliation - Outliers detectionKNIME Hub
- Extract Fuzzy ClustersKNIME Hub
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.