Icon

fuzzy Join two tables with GroupBy and Reference

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 use me laterto get ridof the cross-joinkeepA0join INNERto get fullreference groupjoin LEFTto fill measurementvaluesMath Formula Cross Joiner Table Creator Table Creator Rule Engine Row Filter Similarity Search Row Filter Joiner Joiner 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 use me laterto get ridof the cross-joinkeepA0join INNERto get fullreference groupjoin LEFTto fill measurementvaluesMath Formula Cross Joiner Table Creator Table Creator Rule Engine Row Filter Similarity Search Row Filter Joiner Joiner

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-11
Last update: 2024-04-30
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!