Icon

GroupBy and Separate by Chunks based on List of Strings 2

CREATES A KEYWORD TABLE AS VARIABLE - THIS TABLE INDEXED WILLBE USED TO MATCH WORDS WHEN TRYING TO GROUP THE CHUNKSAND ALSO TO HAVE RULE ENGINE REGEX EXPRESSIONS AND COLUMNEXPRESSIONS READY TO BE USED WHEN SEARCHING FOR THESEKEYWORDS CLEANS UP THE CONFIG COLUMN UP TO THE POINT WHERE WE WILL NEED TO START GROUPING BY CHUNKS Queryingthe VariableselectedTable connectiondomain namefind markersusing regexGet firstmatching rowindexKeep rowsfrom markerindex Marker Indexrequired by row filterKeep cleaned datacolumnConfigKeywordsKeywordsVariable ListConfigKeep cleaned datacolumnNode 12855Node 12856removefirst rownot neededfor upcomingGroupByIndex Query Table Indexer ConstantValue Column Rule Engine GroupBy Row Filter Table Rowto Variable Double To Int Column Filter Excel Reader Table Rowto Variable Excel Reader Column Filter Column Rename RowID Row Filter CREATES A KEYWORD TABLE AS VARIABLE - THIS TABLE INDEXED WILLBE USED TO MATCH WORDS WHEN TRYING TO GROUP THE CHUNKSAND ALSO TO HAVE RULE ENGINE REGEX EXPRESSIONS AND COLUMNEXPRESSIONS READY TO BE USED WHEN SEARCHING FOR THESEKEYWORDS CLEANS UP THE CONFIG COLUMN UP TO THE POINT WHERE WE WILL NEED TO START GROUPING BY CHUNKS Queryingthe VariableselectedTable connectiondomain namefind markersusing regexGet firstmatching rowindexKeep rowsfrom markerindex Marker Indexrequired by row filterKeep cleaned datacolumnConfigKeywordsKeywordsVariable ListConfigKeep cleaned datacolumnNode 12855Node 12856removefirst rownot neededfor upcomingGroupByIndex Query Table Indexer ConstantValue Column Rule Engine GroupBy Row Filter Table Rowto Variable Double To Int Column Filter Excel Reader Table Rowto Variable Excel Reader Column Filter Column Rename RowID Row 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: 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!