Based on a specific XML Node value, find the Value from other Nodes

[srinit86581866]

Hello,

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?

[Jean-foxfly · Accepted solution]

Hi @srinit86581866 

You can do it with xPath. Try this:

//otherAddresses[@publishingTypeID="02"]/@lastName

Jean