Hi,
I have a function that returns me table Struc. I am trying to create another table by going through this table. The new table would contain the ObjectID and the ObjectID of its parent.
In order to find the parent first we have to look at the PUP column corresponding to the Object. This PUP is then matched with another column in the same table SQNR. If PUP = SQNR then we grab the ObjectID corresponding to that SQNR and this is the parent.
What would be an efficient way of achieving this? I would really appreciate the help!!
Thanks.