Update XML with some value in a tag based on ID
The issue where I am stuck is like this…
I have got two xml’s ( generated from Archi ( Data Modelling Tool ) ). I am using XML reader to read from both and XPATH to get ‘identifier’ and ‘name’ Lets say identifier is ‘ia123’ and name is ‘Business Services’. Then doing ‘name’ and doing full antijoin to find missing values on both sides. Assume this is not found in other xmls and the row found in other as in the other xml there is a name ‘Business Services Updated ’ Now, task is to update the first xml based on ID i.e. ‘ia123’ and update the name there with ‘Business Services Updated ’. Any ideas will save my life :-(. Many thanks in advance