For example, in table 1, we have Column name: Keyword Row0 Hello Row1 World Row2 Bye in table 2, we have Column name: Checklist Row0 World Peace Row1 Hello there Now I want to mark each row in table 1 according to if the value is present as a substring of any value in Checklist. The expected result is this new column appended in table 1. Row0 Yes Row1 Yes Row2 No

Hi @user2022 , thank you for confirming. There are a few ways to do this, and here are 2 ways that I put together for you. Method 1: Uses pure knime nodes and relies on the Cross Joiner Method 2: Uses a virtual DB such as H2 where we can do a join using LIKE statement. The workflow has both methods, and looks like this: [image] This is what I used as keywords: [image] This is what I used as Checklist: [image] Results using method 1: [image] Results using method 2: [image] As expected, both gives the same results. If your dataset is big, then the cross joiner might end up with a huge dataset as it will do a cross join (meaning all the possible combinations of Keyword and Checklist), in which case, the virtual DB might be better. You can try both to see what runs best for you. Here’s the workflow: [image] Match keywords as substring of any row in another table – bruno29a Match keywords as substring of any row in another table. This is basically a LIKE comparison.

Match keywords as substring of any row in another table column

KNIME Analytics Platform

victor_palacios July 13, 2022, 10:00pm 5

We’ve also done something similar to this in the Just KNIME It challenges

Here are more solutions to this kind of problem as well:

1 Like