How to compare two string columns?

Hello comunity!

I’m looking to compare two columns in Knime and need to see how similar they are, I’m thinking on doing it by the number of words that they share:

An example will be:

Not sure if the image got loaded but here is an example:
Column A:
Human Resources Manager at Fabri-Kal
Column B:
Manager, Human Resources

As you can see column B and A have 3 words in common (“Manager”, “Human”, “Resources”)
The ideal result will tell me the number of words in common that the two columns have!
Thank you :slight_smile:

Hu @cat_data

Didi you check the String Similarity node?
gr. Hans

4 Likes

Here is an example of the similarity search used in a Just KNIME It! challenge.

2 Likes