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