Icon

Make_​Group_​relationships - revised 2

Finding Relationships (adapted from original workflow by Tobias Koetter)

This workflow extracts all people that are connected to each other using the KNIME Network Mining extension


Extract relationship groups Based heavily on original workflow by Tobias Koetter(all portions not in Blue and Orange boxes are from Tobias)Flow in blue and orange have been addedBLUE: Firstly, RelationshipStrength arbitrarily assumed to be 1. (SubGraph Extractor now finds all network objects)ORANGE: Having found all possible Relationship Networks (subgraphs) it finds the unique set and arbitrarily choosesone from each of those22 April 2021 @takbb Brian Bates (Revision 2 - handle ID-Parent_ID where parent_id may be blank, and parent_id is chosen as Group Name instead ofarbitrary selection) Have removed group colour coding information, asassuming nothing is known at initial stage aboutgroups.Input table now contains only the names, i.e. KeyAand KeyB. Have added a few extra relationships fortesting.RelationShip strength now set to .5 arbitrarily for allas I am going to assume no information aboutrelationship strengths are known. create networkfrom tablenormalize edgeweightdefines depth of friendshipand search for friendsconvert backto networkextract all nodes in thenetworkcollect resultappendoriginuse group loopto retain originfilter node labelAssumes we know nothingabout relationship StrengthsHow wide does the search go outfrom each personid => parent_idFix missing parent(self-reference as parent)Rename keyA and keyBand make into StringsNode 28get parentsGet just the "parent" subgraphsChoose a Group to filterSort by Group, IDRename to Group, IDFilter for a particulargroupPut Group column first Object Inserter Normalizer SubGraph Extractor Row To Network Node Table Loop End Variable toTable Column Group Loop Start Column Filter ConstantValue Column Integer Input Excel Reader Rule Engine Column Rename DuplicateRow Filter Column Filter Joiner String Input Sorter Column Rename Row Filter Column Resorter Extract relationship groups Based heavily on original workflow by Tobias Koetter(all portions not in Blue and Orange boxes are from Tobias)Flow in blue and orange have been addedBLUE: Firstly, RelationshipStrength arbitrarily assumed to be 1. (SubGraph Extractor now finds all network objects)ORANGE: Having found all possible Relationship Networks (subgraphs) it finds the unique set and arbitrarily choosesone from each of those22 April 2021 @takbb Brian Bates (Revision 2 - handle ID-Parent_ID where parent_id may be blank, and parent_id is chosen as Group Name instead ofarbitrary selection) Have removed group colour coding information, asassuming nothing is known at initial stage aboutgroups.Input table now contains only the names, i.e. KeyAand KeyB. Have added a few extra relationships fortesting.RelationShip strength now set to .5 arbitrarily for allas I am going to assume no information aboutrelationship strengths are known. create networkfrom tablenormalize edgeweightdefines depth of friendshipand search for friendsconvert backto networkextract all nodes in thenetworkcollect resultappendoriginuse group loopto retain originfilter node labelAssumes we know nothingabout relationship StrengthsHow wide does the search go outfrom each personid => parent_idFix missing parent(self-reference as parent)Rename keyA and keyBand make into StringsNode 28get parentsGet just the "parent" subgraphsChoose a Group to filterSort by Group, IDRename to Group, IDFilter for a particulargroupPut Group column first Object Inserter Normalizer SubGraph Extractor Row To Network Node Table Loop End Variable toTable Column Group Loop Start Column Filter ConstantValue Column Integer Input Excel Reader Rule Engine Column Rename DuplicateRow Filter Column Filter Joiner String Input Sorter Column Rename Row Filter Column Resorter

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: Tobias
Created at: 2021-04-21
On NodePit since: 2022-02-06
Last update: 2024-04-27
Created with KNIME version: v4.3.2
Tags: network miningsocial network analysismake group

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

Try NodePit Runner!