Icon

Similarity_​check_​test

20211012 Pikairos Compare and match 2 Columns

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

Table 1Split the $Vehicle File 1$into tokens andgenerate a SetRemove Uninformativefor joining CharactersSplit the $Vehicle File 2$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 Tokens Split back thetwo Bit Vectorfrom the twodifferentTablesJoin Bit Vectors toits correspondingInitial Table 2Join resultswith 2nd TableRemove Uninformativefor joining CharactersNode 378Node 379Node 380Node 6311Node 6721Node 6722Node 6725Table 1Node 6899Excel Reader Cell Splitter String Manipulation Cell Splitter Create Bit Vector Similarity Search Joiner Concatenate Rule-basedRow Splitter Joiner Joiner String Manipulation RowID String Manipulation RowID DuplicateRow Filter Column Aggregator Column Aggregator String Manipulation Excel Reader InteractiveTable (local) Table 1Split the $Vehicle File 1$into tokens andgenerate a SetRemove Uninformativefor joining CharactersSplit the $Vehicle File 2$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 Tokens Split back thetwo Bit Vectorfrom the twodifferentTablesJoin Bit Vectors toits correspondingInitial Table 2Join resultswith 2nd TableRemove Uninformativefor joining CharactersNode 378Node 379Node 380Node 6311Node 6721Node 6722Node 6725Table 1Node 6899Excel Reader Cell Splitter String Manipulation Cell Splitter Create Bit Vector Similarity Search Joiner Concatenate Rule-basedRow Splitter Joiner Joiner String Manipulation RowID String Manipulation RowID DuplicateRow Filter Column Aggregator Column Aggregator String Manipulation Excel Reader 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: 2024-03-02
Last update: 2024-04-27
Created with KNIME version: v4.7.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!