3 Replies Latest reply: Jul 13, 2015 3:07 AM by sindhu kannan RSS

    Reorganise data ...

      Hi,

       

      No way to organize data like I need to feed this "directed diagramm" skokenes/QV_Ext-DirectedDiagram · GitHub !!!

      I have this table, describing different records associated with sources (of information) :

       

      Table1 :

      RecordId        Source

      1                       Web

      1                       Email

      2                       Web

      3                       Web

      3                       Email

      3                       FTP

       

      The record 1 is associated with 2 sources : Web" and "Email".

       

      Now, I would like to evaluate the number of connected types through a Record.

      Something like :

       

      Node1          Node2            NbOfCommonRecorded

      Web                Email                     2                 => this line means 2 records have "Web" and "Email" as sources, here n°1 and 3

      Web                FTP                       1                 => this line means 1 record has "Web" and "FTP" as sources, here n°3

      Email              FTP                       1                 => this line means 1 record has "FTP" and "Email" as sources, here n°3

       

      Of course, ideally, each unique couple should not be display twice since "web-email" and "email-web" are strictly the same.

       

      Many thanks for your help ...