Icon

fuzzy Join two tables with GroupBy and Reference

Iteration0: unoptimised solution; actual intput data is 50.000 measurements and 25.000 reference values; iteration1: no Cross-Joiner; assigns nearest neighbor instead --> duplicate measurement values are ignored: Node 606rowcount output =rowcount input 1 *rowcount input 2I eat RAMfor breakfastSampleReference Node 6131st: MolecularFlag A2 (String 2) is missing in the tablebecause there was no match with references masses however I need that in my final table. 2nd: Index 4 is present in this table however I don't want in my final table because A0 is missing keepA0join INNERto get fullreference groupjoin LEFTto fill measurementvaluesreferencetablemeasurementtableNode 621findnearest neighborkeepA0joinINNER(assign nearest neighborto reference table)calcppmfilter bythresholdreduce to groupswith a match in A0removemeasurementswith to big a gapsame, but withppm values Math Formula Cross Joiner Table Creator Table Creator Rule Engine Row Filter Row Filter Joiner Joiner Table Creator Table Creator Column Rename Similarity Search Row Filter Joiner Math Formula Rule-basedRow Filter ReferenceRow Filter Rule Engine Rule Engine Iteration0: unoptimised solution; actual intput data is 50.000 measurements and 25.000 reference values; iteration1: no Cross-Joiner; assigns nearest neighbor instead --> duplicate measurement values are ignored: Node 606rowcount output =rowcount input 1 *rowcount input 2I eat RAMfor breakfastSampleReference Node 6131st: MolecularFlag A2 (String 2) is missing in the tablebecause there was no match with references masses however I need that in my final table. 2nd: Index 4 is present in this table however I don't want in my final table because A0 is missing keepA0join INNERto get fullreference groupjoin LEFTto fill measurementvaluesreferencetablemeasurementtableNode 621findnearest neighborkeepA0joinINNER(assign nearest neighborto reference table)calcppmfilter bythresholdreduce to groupswith a match in A0removemeasurementswith to big a gapsame, but withppm values Math Formula Cross Joiner Table Creator Table Creator Rule Engine Row Filter Row Filter Joiner Joiner Table Creator Table Creator Column Rename Similarity Search Row Filter Joiner Math Formula Rule-basedRow Filter ReferenceRow Filter Rule Engine Rule Engine

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: hupcejov
Created at: 2022-02-10
On NodePit since: 2022-02-15
Last update: 2024-04-27
Created with KNIME version: v4.5.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!