Icon

07 matching non matching strings

There has been no title set for this workflow's metadata.

This workflow comes with my blog post "Matching "Non-Matching" Strings". A Guide to Resolving Non-Matching Records

The data used in the KNIME workflow is not the complete dataset, but a sample to support the methodology described in this blog.

URL: Matching “Non-Matching” Strings (Low code for Data Science) https://medium.com/low-code-for-advanced-data-science/matching-non-matching-strings-41729f2aec9f

all combinationskeep new_entriesmax. similarityLevenshteininteractivselectionapply generatedrulesprepare rulescreate originalcolumnsdefault ruleselected rowsin TableViewrename to original columns namensnew_entriesversion +1similaritytresholdDEMObase listnew entriestitel & artiesttitel & artiestCross Joiner DuplicateRow Filter String Similarity Table View(JavaScript) Rule Engine(Dictionary) String Manipulation Cell Splitter Table Creator Concatenate Row Filter Column Rename(deprecated) Table Writer Row Filter Joiner Table Reader Table Reader Column Aggregator Column Aggregator all combinationskeep new_entriesmax. similarityLevenshteininteractivselectionapply generatedrulesprepare rulescreate originalcolumnsdefault ruleselected rowsin TableViewrename to original columns namensnew_entriesversion +1similaritytresholdDEMObase listnew entriestitel & artiesttitel & artiestCross Joiner DuplicateRow Filter String Similarity Table View(JavaScript) Rule Engine(Dictionary) String Manipulation Cell Splitter Table Creator Concatenate Row Filter Column Rename(deprecated) Table Writer Row Filter Joiner Table Reader Table Reader Column Aggregator Column Aggregator

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: hans
Created at: 2023-06-20
On NodePit since: 2024-01-06
Last update: 2024-04-27
Created with KNIME version: v5.2.0
Tags: Top2000String SimilarityMatching StringsPop SongsString ManipulationRule Engine (Dictionary)

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

Try NodePit Runner!