Icon

Breaking rows by keywords and breaking into column groups

Demonstrating idea of a workflow that can divide rows up into groups based on keywords or key phrases, then place each group into its own column

The magic pattern that turns a single column into multiple columns based ongroupings Sample DataKeywordsMake regex patternMy people will talkto your people..!Which of my peoplegot on withyour people?cumulatively renumber the groupmarkersDiscard anyinitial"unloved" rowsat the beginningRemove unwantedcolumnsEverything 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...Sleight of hand...Now open your eyes...Pull the curtain round Extract Data Tablefrom Delimited Text Extract Data Tablefrom Delimited Text String Manipulation Cross Joiner Rule Engine Moving Aggregation Row Filter Column Filter Column Rename Row Splitter Counter Generation DuplicateRow Filter Concatenate Sorter Joiner GroupBy Transpose Ungroup Column Filter The magic pattern that turns a single column into multiple columns based ongroupings Sample DataKeywordsMake regex patternMy people will talkto your people..!Which of my peoplegot on withyour people?cumulatively renumber the groupmarkersDiscard anyinitial"unloved" rowsat the beginningRemove unwantedcolumnsEverything 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...Sleight of hand...Now open your eyes...Pull the curtain round Extract Data Tablefrom Delimited Text Extract Data Tablefrom Delimited Text String Manipulation Cross Joiner Rule Engine Moving Aggregation Row Filter Column Filter Column Rename Row Splitter Counter Generation DuplicateRow Filter Concatenate Sorter Joiner GroupBy Transpose Ungroup 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: bbate
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!