Hi, I have one column which is a string, anywhere between 1 to 50 words in it. I want to check if it contains a set of words. For example, file 1 has list of words and file 2 has list of names. if file 1 has the names which are in file 2, result should show 1 else 0. List is long(500+) and these are strings in different sizes so simple rules dont work nor does value lookup. I tried matching using string to document → dictionary filter but this removes the words of interest so didnt help. I also tried string to document → dictionary replacer which replaces the word with my tag but i dont know how to proceed thereafter. I also tried dictionary tagger but its not giving the results. I have attached the two files. Can someone help? Thanks dictionary file.xlsx (43.3 KB) data.xlsx (12.3 KB)

I ended up doing the following- Strings to document - dictionary replacer - bag of words creator- term to string - row filter- constant filter- columns filter followed by Joins. Worked.

Dictionary tagging issue

KNIME Analytics Platform

gonhaddock February 16, 2026, 4:26pm 2

Hello @ace2131
You may want to take a look on the following topics. They could address similar challenges to your current needed solution:

[…]

2 Likes