I have a table of recipe ingredients and want to match my list of meat and list of vegetables, to see what I can cook with current ingredients (list of meat and list of vegetables on another two tables with only one column each). The table of recipe ingredients as follows: recipe Meat 1 Meat 2 vege 1 vege 2 vege 3 1. beef egg onion garlic carrot 2. pork beef pepper corn carrot 3. fish pork soybean blackbean corn List of meat = [‘egg’, fish’, ‘beef’, ‘pork’, ‘egg’, ‘fish’, ‘pork’, ‘chicken’] List of vegetables = [‘carrot’, ‘onion’, ‘corn’, ‘soybean’, ‘onion’, ‘garlic’, ‘soybean’, ‘redbean’, ‘blackbean’] I am expecting following results: recipe Meat 1 Meat 2 vege 1 vege 2 vege 3 1. beef egg onion garlic carrot 3. fish pork soybean blackbean corn Result 2 (what are left remaining): List of meat = [‘egg’, ‘fish’, ‘pork’, ‘chicken’] List of vegetables = [‘onion’, ‘soybean’, ‘redbean’, ‘blackbean’]

Hello @anguslou Have a look to this topic, this workflow can be easily adapted to your use case. [image] Filter rows using list of words with wildcards KNIME Analytics Platform Hello @PLS_KN I couldn’t avoid to give this a try. It is based in a Logical Indexing methodology. It doesn’t use the Regex Extractor component (I cannot download it from my network today). [image] With the mentioned logical indexing matrix you can give this workflow some other LOGICAL uses like: when does a word happens when some other is present before… This is an example of the excluded words in your final filter: [image] I hope you find useful this workflow. BR Please let us know if further advise is needed. BR

Intersect table of recipe with ingredients available

KNIME Analytics Platform

gonhaddock November 9, 2022, 11:27am 2

Hello @anguslou

Have a look to this topic, this workflow can be easily adapted to your use case.

Please let us know if further advise is needed.

2 Likes