Icon

data_​cleaning_​v1

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! dataport 0 : data to be modifiedport 2 : data unmodifiedNode 26Node 32Node 33Node 34Node 35Node 36Node 37Node 38count occurrences ofIDsport 0 : data and IDswith max 3 occurrencesconcatenateIDstemp_idNode 43Node 44Node 45Node 46 Table Creator Joiner Column Filter data preparation which IDs have to beremoved and where (3 max) suppress IDs RowID Reconstruction of datain correct format Cell Splitter Ungroup Rank Numeric RowSplitter GroupBy String Manipulation Sorter Column Renamer Column Filter RowID 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! dataport 0 : data to be modifiedport 2 : data unmodifiedNode 26Node 32Node 33Node 34Node 35Node 36Node 37Node 38count occurrences ofIDsport 0 : data and IDswith max 3 occurrencesconcatenateIDstemp_idNode 43Node 44Node 45Node 46 Table Creator Joiner Column Filter data preparation which IDs have to beremoved and where (3 max) suppress IDs RowID Reconstruction of datain correct format Cell Splitter Ungroup Rank Numeric RowSplitter GroupBy String Manipulation Sorter Column Renamer Column Filter RowID

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: 2025-01-12
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!