Icon

forum 71643 - Loop Problem - alternative

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

Find matches and mismatches between tables based on key columns, but handling possible duplication so that if an item appears more than once it matches only once

Node 151Node 152Node 158Node 160Node 161Node 162Node 166Node 167Node 168Node 169sequence numberfor each "key"to ensure only one matchcan be made per entryjoin on "key" columnsand rank (sequence number)all returned to top portfor further reportingNode 176Node 177dummy column needed for rankingdummy column needed for rankingsequence numberfor each "key"to ensure only one matchcan be made per entryjoin on "key" columnsand rank (sequence number)with top=Matchesmiddle=T1 onlybottom = T2 onlyGroup Loop Start Row Filter Row Filter Column Appender Loop End Table View (Labs) Table Row ToVariable Loop Start Table Creator Table Creator Rule Engine Rank Joiner Rule Engine Table View (Labs) ConstantValue Column ConstantValue Column Rank Joiner Node 151Node 152Node 158Node 160Node 161Node 162Node 166Node 167Node 168Node 169sequence numberfor each "key"to ensure only one matchcan be made per entryjoin on "key" columnsand rank (sequence number)all returned to top portfor further reportingNode 176Node 177dummy column needed for rankingdummy column needed for rankingsequence numberfor each "key"to ensure only one matchcan be made per entryjoin on "key" columnsand rank (sequence number)with top=Matchesmiddle=T1 onlybottom = T2 onlyGroup Loop Start Row Filter Row Filter Column Appender Loop End Table View (Labs) Table Row ToVariable Loop Start Table Creator Table Creator Rule Engine Rank Joiner Rule Engine Table View (Labs) ConstantValue Column ConstantValue Column Rank 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: carmela.tiu
Created at: 2023-08-18
On NodePit since: 2023-08-18
Last update: 2024-05-01
Created with KNIME version: v4.7.4

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

Try NodePit Runner!