Icon

justknimeit-35

#1 : KNIME n=77 #2 : AMAZON n =23 #3 : META n=13 Node 1aggregate firts namelast name intoContact NameNode 8insert Contactand lnk (directed)them to theirMAIN_COMPANY1300 nodes783 edgesremove anypartial recordcreate a unoqueRECORD ID(arbitrarynot meaningfull)analyzeextracted nodesMEMBERSCOMPANYMAINNode 17Node 19CapitalizeUpper CaseCOMPANY MAINcreatecompany branchCOMPANY_BRANCHa little bitof wranglingassuming knime.comrepresents knimeetc..create theCOMPANY_MAINcolumnCOMPANYMAIN->BRANCHin case drill down is neededTo which branch of the TOP companydo the contact belongsunpivotingandconcatenatingis the guaranty theconcatenate WILLmatchfilter relevant nodesbased on theselectionRename toNODE LABELandNODE TYPEinsertFeatures likeNODE_TYPEto allow further filteringselect theNODE TYPEwe're interested inNode Type=Company MainNode 36sort theanalysis statsby decreasing orderfor Node degree(nb of connection)isolateTOP 3companies CSV Reader(deprecated) Column Aggregator Network Creator Object Inserter Missing Value String Manipulation Network Analyzer GroupBy GroupBy Unpivoting Unpivoting String Manipulation(Multi Column) String Manipulation String Manipulation Rule Engine GroupBy Concatenate Feature List Filter Column Rename Feature Inserter Row Filter reinstallcol headers InteractiveTable (local) Sorter Row Filter #1 : KNIME n=77 #2 : AMAZON n =23 #3 : META n=13 Node 1aggregate firts namelast name intoContact NameNode 8insert Contactand lnk (directed)them to theirMAIN_COMPANY1300 nodes783 edgesremove anypartial recordcreate a unoqueRECORD ID(arbitrarynot meaningfull)analyzeextracted nodesMEMBERSCOMPANYMAINNode 17Node 19CapitalizeUpper CaseCOMPANY MAINcreatecompany branchCOMPANY_BRANCHa little bitof wranglingassuming knime.comrepresents knimeetc..create theCOMPANY_MAINcolumnCOMPANYMAIN->BRANCHin case drill down is neededTo which branch of the TOP companydo the contact belongsunpivotingandconcatenatingis the guaranty theconcatenate WILLmatchfilter relevant nodesbased on theselectionRename toNODE LABELandNODE TYPEinsertFeatures likeNODE_TYPEto allow further filteringselect theNODE TYPEwe're interested inNode Type=Company MainNode 36sort theanalysis statsby decreasing orderfor Node degree(nb of connection)isolateTOP 3companiesCSV Reader(deprecated) Column Aggregator Network Creator Object Inserter Missing Value String Manipulation Network Analyzer GroupBy GroupBy Unpivoting Unpivoting String Manipulation(Multi Column) String Manipulation String Manipulation Rule Engine GroupBy Concatenate Feature List Filter Column Rename Feature Inserter Row Filter reinstallcol headers InteractiveTable (local) Sorter Row 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: s8309271
Created at: 2022-09-21
On NodePit since: 2022-09-22
Last update: 2024-05-07
Created with KNIME version: v4.2.5

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

Try NodePit Runner!