Icon

20220601 Pikairos Calculate Non-Connected Subgraphs in Relational Graph using Network Mining nodes

20220601 Pikairos Calculate Non-Connected Subgraphs in Relational Graph using Network Mining Nodes
empty networkinsert edgesYour DataSkeleton of the initially created networkExtract allnon-connectedsubgraphsinto separated rowsExtract CurrentGraph NodesLoop overSubgraphsConvert each rowinto a new graphGroup Nodesas Set and asUnique Concatenated ListLoop overall SubgraphsMake surethat the Subgraphsare uniqueAdd Marker #Filter Out ValuesUngroup Clusterof Nodes in SameSubgraphJoin Nodesin Same Subgraphby PairsMake sure there are notsame Pairs Twicewith same Nodesbut in Inverse OrderSort Pairsof NodesBased onFirst Node &then 2nd Node IdentifiersYour DesiredResultGroup by FROMKeep only "Letters"with more thanone edge connexionKeep onlyLetters with more than one connexionand all their realted numbersempty networkinsert edgesInitially created networkRemove pairsof self-matchedJoin Nodesin Same Subgraphby PairsNode 70Check Connectivitysorted NodesNetwork Creator Object Inserter Table Creator Network Viewer(local) SubGraph Extractor Node Table Chunk Loop Start Row To Network GroupBy Loop End(deprecated) DuplicateRow Filter String Manipulation Rule-basedRow Filter RowID Ungroup Joiner Rule-basedRow Filter Sorter InteractiveTable (local) GroupBy Row Splitter ReferenceRow Filter Column Rename Network Creator Object Inserter Network Viewer(local) Rule-basedRow Filter DuplicateRow Filter Column Rename Joiner Concatenate Column Rename Column Rename Joiner Concatenate GroupBy Column Rename empty networkinsert edgesYour DataSkeleton of the initially created networkExtract allnon-connectedsubgraphsinto separated rowsExtract CurrentGraph NodesLoop overSubgraphsConvert each rowinto a new graphGroup Nodesas Set and asUnique Concatenated ListLoop overall SubgraphsMake surethat the Subgraphsare uniqueAdd Marker #Filter Out ValuesUngroup Clusterof Nodes in SameSubgraphJoin Nodesin Same Subgraphby PairsMake sure there are notsame Pairs Twicewith same Nodesbut in Inverse OrderSort Pairsof NodesBased onFirst Node &then 2nd Node IdentifiersYour DesiredResultGroup by FROMKeep only "Letters"with more thanone edge connexionKeep onlyLetters with more than one connexionand all their realted numbersempty networkinsert edgesInitially created networkRemove pairsof self-matchedJoin Nodesin Same Subgraphby PairsNode 70Check Connectivitysorted NodesNetwork Creator Object Inserter Table Creator Network Viewer(local) SubGraph Extractor Node Table Chunk Loop Start Row To Network GroupBy Loop End(deprecated) DuplicateRow Filter String Manipulation Rule-basedRow Filter RowID Ungroup Joiner Rule-basedRow Filter Sorter InteractiveTable (local) GroupBy Row Splitter ReferenceRow Filter Column Rename Network Creator Object Inserter Network Viewer(local) Rule-basedRow Filter DuplicateRow Filter Column Rename Joiner Concatenate Column Rename Column Rename Joiner Concatenate GroupBy Column Rename

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: 2021-09-29
On NodePit since: 2022-06-03
Last update: 2024-04-26
Created with KNIME version: v4.5.2

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

Try NodePit Runner!