Icon

20230406 Pikairos Compare and match 2 Columns 1

20230406 Pikairos Compare and match 2 Columns

This workflow shows how to convert strings into bit vectors using the -Create Bit Vector- node in view to comparing strings using the -Similarity Search- node.

This workflow provides a solution for question asked by TakeAFew in post number 64917 as referenced in link available in the HUB.

Table 1Table 2Split the $Product$into tokens andgenerate a SetRemove Uninformativefor joining CharactersSplit the $technical object$into tokens andgenerate a SetCreate Bit Vectorfrom TokensCompareBit Vectors fromthe two TablesJoin Bit Vectors toits correspondingInitial Table 1Concatenatethe two set of Tables:This is needed becauseBit Vectors should becompatible in termsof known TokensSplit back thetwo Bit Vectorfrom the twodifferentTablesJoin Bit Vectors toits correspondingInitial Table 2Join resultswith 2nd TableRemove Uninformativefor joining CharactersThe matchedProductsNode 17Excel Reader Excel Reader Cell Splitter String Manipulation Cell Splitter Create Bit Vector Similarity Search Joiner Concatenate Rule-basedRow Splitter Joiner Joiner String Manipulation InteractiveTable (local) Math Formula Table 1Table 2Split the $Product$into tokens andgenerate a SetRemove Uninformativefor joining CharactersSplit the $technical object$into tokens andgenerate a SetCreate Bit Vectorfrom TokensCompareBit Vectors fromthe two TablesJoin Bit Vectors toits correspondingInitial Table 1Concatenatethe two set of Tables:This is needed becauseBit Vectors should becompatible in termsof known TokensSplit back thetwo Bit Vectorfrom the twodifferentTablesJoin Bit Vectors toits correspondingInitial Table 2Join resultswith 2nd TableRemove Uninformativefor joining CharactersThe matchedProductsNode 17Excel Reader Excel Reader Cell Splitter String Manipulation Cell Splitter Create Bit Vector Similarity Search Joiner Concatenate Rule-basedRow Splitter Joiner Joiner String Manipulation InteractiveTable (local) Math Formula

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: Molina
Created at: 2021-10-12
On NodePit since: 2023-04-06
Last update: 2024-11-21
Created with KNIME version: v4.7.2
Tags: Text SimilarityBit VectorCreate Bit VectorSimilarity Search

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

Try NodePit Runner!