Icon

20220303 Pikairos creating a sequence in KNIME

There has been no description set for this workflow's metadata.

First Solution based on a Relational Network workflow Second Solution based on a Recursive Loop workflow Your Dataconsideredas nodesCreate EdgesCreatean emptyNetworkInsert Nodeshave a look at thecreated networkUnique Listof NodesInsert EdgesOrdered SequenceAggregate allrows as listSet up themin columnsas you wantKeep onlyFirst rowfor 1st Input PortSecond termFirst termJoin by2nd Term to 1st TermNew First Rownode ColumnConcatenate backthe list of PairsLoop Recursivelyover the listof PairsSend backthe new Tableto the Beginning ofRecursive LoopKeep only 1st RowSplit concatenatedSequencesbased on "," Separator# Rows# of Loop Iterations equal to# Rows -1Take only useful rows Table Creator Cell Splitter Network Creator Object Inserter Network Viewer(local) Unpivoting Column Filter Object Inserter Edge Table GroupBy Split CollectionColumn Column Rename(Regex) Row Splitter String Manipulation String Manipulation Joiner String Manipulation Concatenate RecursiveLoop Start Recursive Loop End Row Filter Cell Splitter Column Rename(Regex) Extract TableDimension Math Formula(Variable) Row Filter First Solution based on a Relational Network workflow Second Solution based on a Recursive Loop workflow Your Dataconsideredas nodesCreate EdgesCreatean emptyNetworkInsert Nodeshave a look at thecreated networkUnique Listof NodesInsert EdgesOrdered SequenceAggregate allrows as listSet up themin columnsas you wantKeep onlyFirst rowfor 1st Input PortSecond termFirst termJoin by2nd Term to 1st TermNew First Rownode ColumnConcatenate backthe list of PairsLoop Recursivelyover the listof PairsSend backthe new Tableto the Beginning ofRecursive LoopKeep only 1st RowSplit concatenatedSequencesbased on "," Separator# Rows# of Loop Iterations equal to# Rows -1Take only useful rows Table Creator Cell Splitter Network Creator Object Inserter Network Viewer(local) Unpivoting Column Filter Object Inserter Edge Table GroupBy Split CollectionColumn Column Rename(Regex) Row Splitter String Manipulation String Manipulation Joiner String Manipulation Concatenate RecursiveLoop Start Recursive Loop End Row Filter Cell Splitter Column Rename(Regex) Extract TableDimension Math Formula(Variable) Row Filter

Nodes

Extensions

Links