Reorganise data ...

[#1]

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 ...

[#2 · Accepted solution]

PFA for solution.

[#3]

Hi kSindhuKannan,

That did the job ! Many thanks.

I'm still working on this solution to well understand it and accomodate it with all the context of my project and evolution coming soon but that's a good way to do.

Many thanks.

Gill

[#4]

You're Welcome.