Well, there is no generic approach in getting this automated as there are many different ways to describe a relationship. In your example you define the relationship as user1.talkName = user2.talkName but there could be others such as user1.lastName eq user2.lastName, etc. In social networks you often take a predefinied relationship such as user1 follows user2. A simple SQL join on your data by comparing the talkName would probably create the required structure. However you will find that a merge like this will produce a link from user1->user2 as well as link from user2->user1 as both are valid conditions for the relationship before. While VA can handle multi-links between entities its a rather confusing network to look at. You may also want to consider introducing additional nodes in your network such as the actual talkName so users who are mentioned in each talk are grouped/clustered together. Also, include some additional measures / categories which you can use to highlight stronger or weaker relationships (VA allows you to visualize this by using wider links or different colors). Maybe check out the OPTGRAPH procedure if you have access to it as this provides a great set of additional network algorithms and can give you additional measures such as Eigenvector or degree - important measures when doing social network analysis. Cheers, Falko
... View more