Icon

GroupBy-v4

The magic pattern that turns a single column into multiple columns based on groupings Sample DataMake regex patternEverything in place,the rows are groupedby unique group idReady for the magic?Top is the lines wherethe marker matched.Bottom is lines where marker didn't matchThe top port will contain NO DUPLICATESThe lower port needs to haveDUPLICATES REMOVEDWe need an idthat we can sort onto keep things in theright orderafter we've done some cleaning up. We alsoneed to spot the duplicates created by the cross joiner weare about to useRemove duplicates(keep first)One big family againOne happy familyagainUse RIGHT JOIN Remove rows containingkeywords. They should only bein the top, and will be here only wherecrossjoiner put them against the "wrong" keywordClose your eyes...Slight of hand...Now open your eyes...Pull the curtain roundKeywordsMy people will talkto your people..!Which of my peoplegot on withyour people?cumulatively renumber the groupmarkersDiscard anyinitial"unloved" rowsat the beginningRemove unwantedcolumnsKeywordsMy people will talkto your people..!KeywordsExtract Data Tablefrom Delimited Text String Manipulation Column Rename Row Splitter Counter Generation DuplicateRow Filter Concatenate Sorter Joiner GroupBy Transpose Ungroup Column Filter Extract Data Tablefrom Delimited Text Cross Joiner Rule Engine Moving Aggregation Row Filter Column Filter Extract Data Tablefrom Delimited Text Cross Joiner Extract Data Tablefrom Delimited Text The magic pattern that turns a single column into multiple columns based on groupings Sample DataMake regex patternEverything in place,the rows are groupedby unique group idReady for the magic?Top is the lines wherethe marker matched.Bottom is lines where marker didn't matchThe top port will contain NO DUPLICATESThe lower port needs to haveDUPLICATES REMOVEDWe need an idthat we can sort onto keep things in theright orderafter we've done some cleaning up. We alsoneed to spot the duplicates created by the cross joiner weare about to useRemove duplicates(keep first)One big family againOne happy familyagainUse RIGHT JOIN Remove rows containingkeywords. They should only bein the top, and will be here only wherecrossjoiner put them against the "wrong" keywordClose your eyes...Slight of hand...Now open your eyes...Pull the curtain roundKeywordsMy people will talkto your people..!Which of my peoplegot on withyour people?cumulatively renumber the groupmarkersDiscard anyinitial"unloved" rowsat the beginningRemove unwantedcolumnsKeywordsMy people will talkto your people..!KeywordsExtract Data Tablefrom Delimited Text String Manipulation Column Rename Row Splitter Counter Generation DuplicateRow Filter Concatenate Sorter Joiner GroupBy Transpose Ungroup Column Filter Extract Data Tablefrom Delimited Text Cross Joiner Rule Engine Moving Aggregation Row Filter Column Filter Extract Data Tablefrom Delimited Text Cross Joiner Extract Data Tablefrom Delimited Text

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: acampos
Created at: 2022-11-11
On NodePit since: 2022-11-12
Last update: 2024-04-27
Created with KNIME version: v4.6.3

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

Try NodePit Runner!