Network Map

kamtaot · February 17, 2025, 2:32pm

Hello there,

I am doing an analysis to find out the related customers and their distance if a customer ID is provided. For e.g.,

A - is the primary customer ID which has SSN, Mobile Number, Email ID and CR Number. So A is customer 0.
W - is having the same mobile number, hence W is at distance 1.
K - is having same email ID and SSN same as A, hence K is also at distance 1 but a different mobile number.
P - having same mobile number of K but there is nothing in common with A. As A is related to K with email ID and SSN, and P is having same mobile as K, P is a distance of 2 from A.
M - having same email ID of P, then M is at a distance of 3 from A.

I did this whole network in a tabular format from 6 million customers that we have. Now, I want to display a nice network map something like below.

Please suggest me how to do this. If you want I can share some dummy data in the format. Any suggestions are welcome.

rfeigel · February 18, 2025, 4:13am

Some data would help. Any common format is ok.

rfeigel · February 19, 2025, 3:59am

It would be a lot easier for potential helpers if you uploaded your data in a file.

kamtaot · February 19, 2025, 9:07am

Hi @rfeigel, My organization does not allow to upload any data. I can only copy and paste. Hence, I took this approach. Let me see, if I can put in a CSV file and share it again.
distance_to_share.csv (2.0 KB)

rfeigel · February 20, 2025, 5:22pm

Could you explain what you’re trying to network, i.e. customer names? Also some of the data elements are unclear as to how they would be used:
Customer Number Previous
Match
Email ID - many missing
CR_NO
Mobile_No - many duplicates which seems odd.
I’ve tried to pare down the dataset, but I’m unsure what to use.

rfeigel · March 4, 2025, 4:26pm

You haven’t replied to my last post. I developed a workflow which produces this network with the object configuration below. Its the best I could do with the data you supplied. Maybe others can do better.