Icon

KNIME_​project

DOES NOT WORK TO "EXCLUDE" VALUES-> output has many more rows that initial table; for such little amount of rows it's OK but that def does not work when dealing with over 2M records WORKS fine to INCLUDE values (which is not what I need unfortunately).Using this method, then an anti-join is needed ie extra step descriptionslist of wordsuppercasesearch each wordsearch match in each rowmatches for each word/rowupper casesearch match in each rowmatches for each word/rowlist of wordssearch each worduppercase Table Creator Table Creator String Manipulation Table Row ToVariable Loop Start Row Filter Loop End String Manipulation Row Filter Loop End Table Creator Table Row ToVariable Loop Start String Manipulation DOES NOT WORK TO "EXCLUDE" VALUES-> output has many more rows that initial table; for such little amount of rows it's OK but that def does not work when dealing with over 2M records WORKS fine to INCLUDE values (which is not what I need unfortunately).Using this method, then an anti-join is needed ie extra step descriptionslist of wordsuppercasesearch each wordsearch match in each rowmatches for each word/rowupper casesearch match in each rowmatches for each word/rowlist of wordssearch each worduppercaseTable Creator Table Creator String Manipulation Table Row ToVariable Loop Start Row Filter Loop End String Manipulation Row Filter Loop End Table Creator Table Row ToVariable Loop Start String Manipulation

Nodes

Extensions

Links

Download

To use this workflow in KNIME, download it from the below URL and open it in KNIME:

Download Workflow
Created by: patricia.llull
Created at: 2022-05-03
On NodePit since: 2022-05-04
Last update: 2024-05-01
Created with KNIME version: v4.4.2

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!