Detect words and set value for it, e.g. find categories in text

[JulesD]

Hello Knime community,
I have large amounts of product data organized in columns and rows.
I am trying to get (amongst other) the “categories” for my products by matching them against a category list. Let’s say in the data there is the term “ski jacket”. According to my category list that should be categorized as a “winter jacket”.

So I concatenated all the columns that potentially contain the category information for each row
(= each row equals a product) and I was able to tag it as “ski jacket” using the dictionary tagger, but now I am stuck. How do I get the information that it is a “winter jacket” in now?

Are there in general also better ways to do that?

Hope someone can help.

Thanks,
Julia

[lelloba]

Hello JulesD,

here is a link to a post with several solutions that could help you:

Solutions to "Just KNIME It!" Challenge 18

This thread is for posting solutions to “Just KNIME It!” Challenge 18. Feel free to link your solution from KNIME Hub as well! Here is the challenge of the week: Just KNIME It! | KNIME Have an idea for a challenge? We’d love to hear it! Please write it here . And remember: the more you participate, the more participation badges you may end up getting. Fancy, huh? Just remember to correctly mark your solution in the Hub with tag justknimeit-18.

If this is not helping you, can you provide a small example workflow, so I can better help you?

Thank you,
RB

[JulesD]

Hello lelloba,
thanks a lot, that helps and I guess one of the solutions provided will work in my case.

Kind regards,
Jules