Icon

20211012 Pikairos Compare and match 2 Columns

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

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 matchedProductsExcel 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) 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 matchedProductsExcel 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)

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: 2022-02-06
Last update: 2024-04-23
Created with KNIME version: v4.4.1

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

Try NodePit Runner!