Hello group, Working with KNIME, and my dataset. I needed to make the comparison between existing references in 2 different columns. What is my problem, and that’s why I ask for your help… As an example, I have in column A has the reference AAA11122222BBB-333CCC and column B to compare is 0AA11121222BBBB333CC. As you can see some character or some is changed, but both strings match at 80% and therefore I would like that for that case it appears as “match” between both. Can someone help me to do the Workflow? Thanks in advance

Hello @26AngelG , To achieve this result, you can use both the String Similarity node and the Java Snippet node. I used the Java Snippet node. In the Java Snippet node, you can write logic like Comparation between 2 Column.knwf (73.8 KB) "String valueA = c_column1; String valueB = c_column2; int dp = new int[valueA.length() + 1][valueB.length() + 1]; for (int i = 0; i <= valueA.length(); i++) { dp[i][0] = i; } for (int j = 0; j <= valueB.length(); j++) { dp[0][j] = j; } for (int i = 1; i <= valueA.length(); i++) { for (int j = 1; j <= valueB.length(); j++) { int cost = (valueA.charAt(i - 1) == valueB.charAt(j - 1)) ? 0 : 1; dp[i][j] = Math.min(Math.min(dp[i - 1][j] + 1, dp[i][j - 1] + 1), dp[i - 1][j - 1] + cost); } } int levenshteinDistance = dp[valueA.length()][valueB.length()]; double threshold = 0.8; double maxLen = Math.max(valueA.length(), valueB.length()); double similarityScore = 1.0 - (double) levenshteinDistance / maxLen; String matchStatus = (similarityScore >= threshold) ? “Match” : “No Match”; out_new = matchStatus;". output [Screenshot 2024-04-23 154723]

Comparation between 2 columns no exactly 100%

KNIME Analytics Platform

rfeigel May 11, 2024, 1:53pm 11

Take a look at this recent post.

1 Like