Icon

LocationExample Recursive Loop

Your nodes go here! Pre-define the columns that the loop is going to be"creating" Create the variables required to replicate the Table Column Loop Additional nodes required to replicate "Column List Loop" functionality, and supply "current column" variable Inizializzo variabiliNode 33Node 46Node 49Node 53Node 55Node 56Node 58Node 59Specify iteration countusing flow variableCreate Where-clauseColumnCreate Where-clauseColumnNode 63Get just location columnsGet column countInclude column countGet column namesMake into a listColumn listas variableNode 70Node 71currentColumnNameremove column namefrom list Remove Old Column NameStringAnd also remove old copies of columns being built by Column EpxressionsReduced list ofcolumn namesto pass to next iterationPull newly updated columnsinto next iteration alongwith ever-reducingColumn Name listNode 77Collect Column Name listfrom data tableand turn into variableRemove superfluous columnsGroup the columnsVariable Creator Table Creator Column Expressions Cell Splitter Column ListLoop Start Column Expressions Column Rename(Regex) Column Rename(Regex) Loop End RecursiveLoop Start Recursive Loop End String Manipulation String Manipulation Math Formula Column Filter Extract TableDimension Variable toTable Column Extract Table Spec GroupBy Table Rowto Variable Column Rename(Regex) Column Expressions String Manipulation(Variable) String Manipulation(Variable) Column Filter Variable toTable Column Joiner Column Rename(Regex) Table Rowto Variable Column Filter GroupBy Your nodes go here! Pre-define the columns that the loop is going to be"creating" Create the variables required to replicate the Table Column Loop Additional nodes required to replicate "Column List Loop" functionality, and supply "current column" variable Inizializzo variabiliNode 33Node 46Node 49Node 53Node 55Node 56Node 58Node 59Specify iteration countusing flow variableCreate Where-clauseColumnCreate Where-clauseColumnNode 63Get just location columnsGet column countInclude column countGet column namesMake into a listColumn listas variableNode 70Node 71currentColumnNameremove column namefrom list Remove Old Column NameStringAnd also remove old copies of columns being built by Column EpxressionsReduced list ofcolumn namesto pass to next iterationPull newly updated columnsinto next iteration alongwith ever-reducingColumn Name listNode 77Collect Column Name listfrom data tableand turn into variableRemove superfluous columnsGroup the columnsVariable Creator Table Creator Column Expressions Cell Splitter Column ListLoop Start Column Expressions Column Rename(Regex) Column Rename(Regex) Loop End RecursiveLoop Start Recursive Loop End String Manipulation String Manipulation Math Formula Column Filter Extract TableDimension Variable toTable Column Extract Table Spec GroupBy Table Rowto Variable Column Rename(Regex) Column Expressions String Manipulation(Variable) String Manipulation(Variable) Column Filter Variable toTable Column Joiner Column Rename(Regex) Table Rowto Variable Column Filter GroupBy

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: Atti
Created at: 2022-10-17
On NodePit since: 2022-10-18
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!