PROVISION_ID : 20
provision_id_begin : 1
provision_id_end : 2
provision_id_begin : 2
provision_id_end : 3
provision_id_begin : 3
provision_id_end : 4
I don’t understand your sample data. Are the begin/end supposed to be Node IDs, and the provision_id is the link id? (ie. Link with Provision ID 20 links begins at Node 1 and ends at Node 2.)
OK, I think you’re asking how do you iterate the tables to create the nodes and links…
This code is not working so If possible please send a sample like this.
That was meant to be pseudo-code. not something you could plug in and run. I don’t know the structure of your database, so it wouldn’t be possible for me to do that.
I don’t understand how one link (L20) can link 3 separate pairs of nodes…
We do not want to link 3 node.We just want to link only 2 node with the help of (L20) .
So go back and read what I wrote on Dec 6. You need 2 tables: 1 for Nodes, and 1 for links.