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

Avatar

Avatar

srinit86581866

Avatar

srinit86581866

srinit86581866

06-03-2019

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?

1706723_pastedImage_0.png

Accepted Solutions (1)

Accepted Solutions (1)

Avatar

Avatar

Jean-foxfly

Avatar

Jean-foxfly

Jean-foxfly

28-07-2020

Hi @srinit86581866 

You can do it with xPath. Try this:

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

 

Jean

Answers (0)