Network Analysis Tool

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

Linked in Network.yxmd

Predictive Analysis

Accepted answers

chris_love

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.

Linked in Network (1).yxmd

Tim_Napier

This version shows relationships via company, hope you like! My linked in network via the company.PNG

Linked in Network Me to Company.yxmd

All comments

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

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.

Linked in Network (1).yxmd

Tim_Napier

Thanks Chris, works a treat

Aguisande

Great job guys!

Is awesome how "flowery" you got!

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.

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

Sample.yxmd

tnharper

This is a great solution ! But I am getting an error with the Network Analysis tool with Alteryx version 2018.3:
1.) "Tool #4: Error in graph.data.frame(d=x,directed=directed,vertices=vertices):"
2.) "Tool #4: Execution halted"
3.) "Tool #4: The R.exe exit code (1)indicated an error."

Here's my node table structure:

_NAME_

1003002379

Here's my edges table structure:

FROM	TO
1003002379	1225204886
1003002379	1568501054
1003002379	1649364696
1003002379	1952349177

Not sure what I'm missing here. Any help would be much appreciated!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15878

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703