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

[tnharper]

This is a great article! 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!

[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!

[lmorrell]

Hi @tnharper 

Solution is attached.

The below error occurs when the Node datastream does not account for the nodes specified in the From-To datastream.

"Error in graph.data.frame(d=x,directed=directed,vertices=vertices):

Execution halted

The R.exe exit code (1)indicated an error."

In your example, the relationship in row 1 (1003002379 to 1225204886) has the "From" node accounted for, but the R code will error when it tries to process the "To" node as this was not accounted for in the Node datastream. 

One quick fix for this is to generate the Node dataset from your relationships so that the only nodes presented are those that are relational as in the screenshot below.

By unioning the "FROM" and "TO" columns and taking only the unique nodes, this will generate a complete list as below:

_NAME_

1003002379

1225204886

1568501054

1649364696

1952349177

Hope this helps!