Icon

20220304 Pikairos creating a sequence in KNIME

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 wantA different wayof getting thesame Result (2)Keep onlyFirst row asRecursive LoopInput DataExtractSecond termExtractFirst termof PairsJoin by2nd Termto1st TermNew First RowmatchedSequenceof PairsLoop Recursivelyover the listof Pairs tomatch them inthe Right OrderSend backthe newSequence of Pairsto the Beginning ofthe Recursive LoopSplit into ColumnsconcatenatedSequencebased on "," Separator# Rows# of RecursiveLoop Iterations equal to# Rows -1Take only useful rowsUnique Listof NodesA different wayof getting thesame Result (1)Keep onlyFirst RowUnique matchedSequence ofPairsTable 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 RecursiveLoop Start Recursive Loop End Cell Splitter Column Rename(Regex) Extract TableDimension Math Formula(Variable) Row Filter Column Filter Transpose Column Rename(Regex) Row Filter Column 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 wantA different wayof getting thesame Result (2)Keep onlyFirst row asRecursive LoopInput DataExtractSecond termExtractFirst termof PairsJoin by2nd Termto1st TermNew First RowmatchedSequenceof PairsLoop Recursivelyover the listof Pairs tomatch them inthe Right OrderSend backthe newSequence of Pairsto the Beginning ofthe Recursive LoopSplit into ColumnsconcatenatedSequencebased on "," Separator# Rows# of RecursiveLoop Iterations equal to# Rows -1Take only useful rowsUnique Listof NodesA different wayof getting thesame Result (1)Keep onlyFirst RowUnique matchedSequence ofPairsTable 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 RecursiveLoop Start Recursive Loop End Cell Splitter Column Rename(Regex) Extract TableDimension Math Formula(Variable) Row Filter Column Filter Transpose Column Rename(Regex) Row Filter 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: Molina
Created at: 2022-03-03
On NodePit since: 2022-03-04
Last update: 2024-04-26
Created with KNIME version: v4.4.1

Deploy, schedule, execute, and monitor your KNIME workflows locally, in the cloud or on-premises – with our brand new NodePit Runner.

Try NodePit Runner!