Icon

data_​cleaning_​v0

https://forum.knime.com/t/remove-occurrence-of-a-text-on-other-rows-if-it-appeared-more-than-3-times-already/83266Hi, I’m really confused on how loops work here or if I even need a loop to get the output I need.I have a column that has delimited values of IDs, sample:row IDs1 one1;two2;three3;four4;five52 one1;three3;four4;five5;six63 one1;seven7;four4;eight8;nine94 one1;two2;three3;nine95 one1;two2;four4;ten10I want my output to be:row IDs1 one1;two2;three3;four4;five52 one1;three3;four4;five5;six63 one1;seven7;four4;eight8;nine94 two2;three3;nine9 --------------------------> removed one15 two2;ten10 --------------------------> removed one1 & four4My goal is to have only 3 at max occurrences of an ID for all of the rows of the data table.Help me please! dataNode 2formating IDs in listNode 12number occurrences per IDscreate idport 0 : IDs max 3port 1 : IDs to be suppressedNode 16counter of occurenceport 0 : data unmodifiedport 1 : data to be modifiedport 0 : data to be modifiedport 2 : data unmodifiedIDs to suppressed and whereExclusive or between list of IDsformatingNode 25Node 26reconstruction of initial dataNode 28Node 29Node 30Node 31 Table Creator Cell Splitter Column Aggregator Ungroup GroupBy String Manipulation Numeric RowSplitter Ungroup Rank Numeric RowSplitter Joiner GroupBy Column Aggregator Column Expressions Column Filter Column Filter Concatenate Sorter Column Resorter Column Merger Column Filter https://forum.knime.com/t/remove-occurrence-of-a-text-on-other-rows-if-it-appeared-more-than-3-times-already/83266Hi, I’m really confused on how loops work here or if I even need a loop to get the output I need.I have a column that has delimited values of IDs, sample:row IDs1 one1;two2;three3;four4;five52 one1;three3;four4;five5;six63 one1;seven7;four4;eight8;nine94 one1;two2;three3;nine95 one1;two2;four4;ten10I want my output to be:row IDs1 one1;two2;three3;four4;five52 one1;three3;four4;five5;six63 one1;seven7;four4;eight8;nine94 two2;three3;nine9 --------------------------> removed one15 two2;ten10 --------------------------> removed one1 & four4My goal is to have only 3 at max occurrences of an ID for all of the rows of the data table.Help me please! dataNode 2formating IDs in listNode 12number occurrences per IDscreate idport 0 : IDs max 3port 1 : IDs to be suppressedNode 16counter of occurenceport 0 : data unmodifiedport 1 : data to be modifiedport 0 : data to be modifiedport 2 : data unmodifiedIDs to suppressed and whereExclusive or between list of IDsformatingNode 25Node 26reconstruction of initial dataNode 28Node 29Node 30Node 31 Table Creator Cell Splitter Column Aggregator Ungroup GroupBy String Manipulation Numeric RowSplitter Ungroup Rank Numeric RowSplitter Joiner GroupBy Column Aggregator Column Expressions Column Filter Column Filter Concatenate Sorter Column Resorter Column Merger 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: polletj
Created at: 2024-09-16
On NodePit since: 2024-09-17
Last update: 2024-11-24
Created with KNIME version: v5.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!