I have an XML document that links to two further XML documents, I need to take the first and run a calculation from a value off the second, and from this produce a third file.
I am iterating through the first using an for-each loop, after opening the document with the document command, writing ourput as I go.
When I come to a point where the identifiying variable is, I am trying to then go into the second XML document to retrieve the data I need, this is where I am struggling.
I am under the impression that I have moved down the tree to the point in XML file 1, then I must go up the tree to the first XML document that links the two files to then enter the second linked document containing the data.
I can't see how I can get data betwwen the two documents.
If anyone understands this can they plz help!
Thanks in advance.