Network Analysis Tool

[Tim_Napier]

Hi all

I've downloaded my contact data from LinkedIn, I was hoping to put it into the Network Analysis tool and show off my contacts etc. I keep getting

Error: Network Analysis (16): Tool #4: Error in graph.data.frame(d = x, directed = directed, vertices = vertices) :

When I try to do this.

Can anyone shed some light on what I should be doing? The workflow is attached. I am thinking it is something stupid like column names wrong, or a missing column or ....

Thanks for any input

[AdamR_AYX]

I think your problem is that dataset doesn't contain everything you need.  For the Network Analysis tool you need a list of who is connected to who.

e.g.

From	To	Weight
Adam Riley	Mickey Mouse	1
Adam Riley	Donald Duck	1
Adam Riley	Minnie Mouse	1
Mickey Mouse	Minnie Mouse	1

That dataset from LinkedIn is just everyone who is connected to you and not how they are connected to each other.

[chris_love · Accepted solution]

Nice challenge on a new tool :-)

Looks like you need to remove blanks, remove duplicates on the name and ensure name is called _name_

I've attached my module, you'll need to switch it back to you LinkedIn file as I've been using mine for testing.

Bear in mind you'll only have which companies each person is attached to, not their connections between each other.

[Tim_Napier]

Thanks Chris, works a treat

[Tim_Napier]

For those who are interested, I added myself as a from with an append tool to all of the other contacts (me as the centre of the universe:-) and get. I've taken Chris's enhancements and added that here for anyone who wants it.

[Aguisande]

Great job guys!

Is awesome how "flowery" you got!

[Tim_Napier · Accepted solution]

This version shows relationships via company, hope you like!

[Trao]

Is there a way we can show a dynamic network visualisation tool in Powerpoint.  Right now, we can only show a static image on a browser. 

[Aguisande]

Hi Trao,

The only idea that I can find is to render to an HTML, then insert the HTML in Powerpoint.

[HK]

Hi All,

I am trying to plug in my own dummy data into the current Alteryx “Network Analysis” sample workflow tool, but I’m running into the same error. I tried the same suggestions thats worked above,  but it seems to still fail.

Any ideas?

_name_	FirstName
555-111-1111	Alex
555-222-2222	Bob
555-333-3333	Christ
555-444-4444	Dan

from	to	weight
555-111-1111	555-222-2222	2
555-111-1111	555-333-3333	1
555-111-1111	555-444-4444	1
555-222-2222	555-222-2222	1
555-222-2222	555-333-3333	3
555-222-2222	555-444-4444	4
555-333-3333	555-333-3333	2
555-333-3333	555-444-4444	1
555-333-3333	555-666-6666	1
555-333-3333	555-222-2222	1
555-444-4444	555-333-3333	1
555-444-4444	555-222-2222	4
555-444-4444	555-555-5555	1
555-444-4444	555-666-6666	3