Icon

20220328 Pikairos Basket Players Matching

This workflow shows how to calculate the similarity between sentences represented by bit vectors where bits represent the presence or absence of a given word in the sentence.

Basket DataBasket PlayersSplit the $Title$into tokens andgenerate a SetSplit the $Players$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 2Remove Uninformativefor joining CharactersThe matchedSimilar NotesSet here the levelof Similarity:Set now between0 % and 100 %of same wordsRemove Uninformativefor joining CharactersExcel Reader Excel Reader Cell Splitter Cell Splitter Create Bit Vector Similarity Search Joiner Concatenate Rule-basedRow Splitter Joiner String Manipulation InteractiveTable (local) Row Filter RowID RowID String Manipulation Ungroup Ungroup ReferenceRow Filter GroupBy ReferenceRow Filter GroupBy Basket DataBasket PlayersSplit the $Title$into tokens andgenerate a SetSplit the $Players$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 2Remove Uninformativefor joining CharactersThe matchedSimilar NotesSet here the levelof Similarity:Set now between0 % and 100 %of same wordsRemove Uninformativefor joining CharactersExcel Reader Excel Reader Cell Splitter Cell Splitter Create Bit Vector Similarity Search Joiner Concatenate Rule-basedRow Splitter Joiner String Manipulation InteractiveTable (local) Row Filter RowID RowID String Manipulation Ungroup Ungroup ReferenceRow Filter GroupBy ReferenceRow Filter GroupBy

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: 2022-03-29
On NodePit since: 2023-03-09
Last update: 2024-04-28
Created with KNIME version: v4.4.1
Tags: Create 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!