Hi @daniel_yi,
maybe the Similarity Search node is the right one for you? The KNIME Distance Matrix extension provides a couple of helper nodes to create distance information from rows. However, you either have to devise your own distance measure using Aggregated Distance or turn your nominal column into a numeric one and use one of the Numeric Distances node’s options.
Kind regards
Alexander
2 Likes