I need to loop trough an xml file and look for a certain fieldname(otherAddresses). There are about 6 fields named otherAddresses and each of them has a field named "PublishingTypeID". Now, depending on the value of PublishingTypeID, I have to select that specific OtherAddresses field and get the value from it's Childfields.
So, for example. If otherAddresses.publishingTypeID has a value of 2, I have to get the value of otherAddresses.lastName from that specific otherAddresses field.
The image below will probably clear up any confusion.
Could anyone help me loop through this?