Consolidate text values that are most similar in a column

Using V5

I have a column of text values with different writings and want to consolidate the different values into the most frequent ones.

Example:
image

The 1st and 3rd should become the same as the 2nd block. So, first need a rank of the values, and than a matching of lower ranked values to maybe higher ranked one.

String Similarity or Similarity Search Nodes might be of help.
br

3 Likes

@robert_m_muench you could take a look at this approach:

1 Like

This topic was automatically closed 90 days after the last reply. New replies are no longer allowed.