Need help setting up Data within Node XL

Dec 1, 2014 at 4:06 PM
Hi everyone!

Does anyone knows if there's a way to automatically arrenge a set of data that looks like this Image into a NodeXL vertex 1 and vertex 2 traditional file?

On the picture you'll find some Twitter data where "vertex1" are the users who originally posted the messages while on the other rows I have all the users that where reached via that particular tweet by the "vertex 1" user. I know I can manually do this but since my data base has around 18000 tweets I was wondering if anyone knows someway to do this without having to manually copy paste and re write the whole data base.

By the way im a new user of nodexl and sorry if my english is not the best, im from Chile, South America.

Thanks for your help!
Dec 3, 2014 at 4:23 PM

it looks like you have your data organized as a matrix. Try using the "Import From Open Matrix Workbook..." option.

Dec 3, 2014 at 5:11 PM

Thank you for the interest in NodeXL!

Edges in NodeXL can only have two vertices:
 Vertex1, Vertex2
If there are other people (Vertex3, for example) related to Vertex 1, they need their own row:
 Vertex1, Vertex3