Icon

KNIME_​remove_​duplicates

Sample DataCode, Subcode, Value, Value2Filter but KEEPand mark rowsTesting for uniqueCode,Subcode combinationKeep only rowsmarked "unique" Remove the duprow marker columnGet Row Countgrouping by key columnsCode, SubcodeKeep only rowswith count=1Inner join on Code, SubcodeRemember to exclude all columns from "right" (lower port) so you have your original columnsTable Creator DuplicateRow Filter Row Filter Column Filter GroupBy Row Filter Joiner Sample DataCode, Subcode, Value, Value2Filter but KEEPand mark rowsTesting for uniqueCode,Subcode combinationKeep only rowsmarked "unique" Remove the duprow marker columnGet Row Countgrouping by key columnsCode, SubcodeKeep only rowswith count=1Inner join on Code, SubcodeRemember to exclude all columns from "right" (lower port) so you have your original columnsTable Creator DuplicateRow Filter Row Filter Column Filter GroupBy Row Filter 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: @takbb Brian Bates
Created at: 2021-05-12
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.3.2

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

Try NodePit Runner!