Icon

Set value on row comparison

sample datacombined columnsto be testedinto a "signature"join rows by "signature"sequentialcounter to aidrow identificationKeep only wherejoined rows weredifferent rowsbut had same "signature"mark where joinedrows were thesame rowexclude rows wheresignature contains anyunknownsRemove duplicatesignaturesKeep justsignature columnMatch signature rowsSet Cleared to YesBring back rowswhere signaturesmatched, and thosewhere they didn'tPut back in original ordertidy upTable Creator Column Combiner Joiner Counter Generation Row Filter Rule Engine Row Filter DuplicateRow Filter Column Filter Joiner String Manipulation Concatenate Sorter Column Filter sample datacombined columnsto be testedinto a "signature"join rows by "signature"sequentialcounter to aidrow identificationKeep only wherejoined rows weredifferent rowsbut had same "signature"mark where joinedrows were thesame rowexclude rows wheresignature contains anyunknownsRemove duplicatesignaturesKeep justsignature columnMatch signature rowsSet Cleared to YesBring back rowswhere signaturesmatched, and thosewhere they didn'tPut back in original ordertidy upTable Creator Column Combiner Joiner Counter Generation Row Filter Rule Engine Row Filter DuplicateRow Filter Column Filter Joiner String Manipulation Concatenate Sorter Column Filter

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: brian
Created at: 2022-01-26
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.5.0

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

Try NodePit Runner!