Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 ...
PFA for solution.
PFA for solution.
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
You're Welcome.