Dictionary tagging issue

[ace2131]

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)

[gonhaddock]

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

Search 1 word in a cell with multiple words

Hello Everyone, I have one excel file with a list of allowed words to be checked in the second. they both have an ID column to make the match. here an example: file1: ID Words1 231 tree 432 apple 511 mug 434 cat File 2: ID Words2 231 tree, bee 432 car 511 mug, cherry, nut 434 dog I want to highlight for the same ID all cells of file2 where words2 are not contained in words1 in file1. In the case of mul…

[…]

Append the Searchkey to a New Column

Hi everyone, I managed to filter the data with certain keywords but I want to specify the keyword with a new column. Anyone knows how I can do it? In the knimeflow attached, I try to find products with keyword “Apple” or “Banana”. And I want to show the filtered result with the keyword in the same row. For example, Column1 Column2 ApppleJuice Apple Find Keyword.knwf (13.1 KB)

BR

[rfeigel]

Why doesn’t the Value Lookup node work?

[ace2131]

tried didnt work. but i have written my solution below

[ace2131]

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.