Icon

KNIME_​ref_​data_​partial_​match 2

Option 2 - using document / dictionary method Option 1 - cross join and search for substring Sample DataRef TableJoin everything with everythingIs the "Standard" columncontained in ColumnA?Remove non-matchesRename "Code"to "Column C"Remove old Column Cand redundant"Standard"columnSample DataRef TableNode 12Replace "Document" with matching lookup fromRef TableGo get the keyTidy up the superfluouscolumnsRename cols to get"Column B"and "Column C"Duplicate "Standard" columnas "Key", as Dictionary Replacerrequires two different columnsExtract the "key"from the documentthat resulted from thelookup Table Creator Table Creator Cross Joiner Column Expressions Row Filter Column Rename Column Filter Table Creator Table Creator Strings To Document Dictionary Replacer Cell Replacer Column Filter Column Rename Rule Engine Document DataExtractor Option 2 - using document / dictionary method Option 1 - cross join and search for substring Sample DataRef TableJoin everything with everythingIs the "Standard" columncontained in ColumnA?Remove non-matchesRename "Code"to "Column C"Remove old Column Cand redundant"Standard"columnSample DataRef TableNode 12Replace "Document" with matching lookup fromRef TableGo get the keyTidy up the superfluouscolumnsRename cols to get"Column B"and "Column C"Duplicate "Standard" columnas "Key", as Dictionary Replacerrequires two different columnsExtract the "key"from the documentthat resulted from thelookup Table Creator Table Creator Cross Joiner Column Expressions Row Filter Column Rename Column Filter Table Creator Table Creator Strings To Document Dictionary Replacer Cell Replacer Column Filter Column Rename Rule Engine Document DataExtractor

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: @takbb Brian Bates
Created at: 2021-05-17
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.3.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!