Get Parent Node value from child condition
Not sure I described this correctly in the Title, but anyway here is my sample XML:
<Unit>
<UnitQualifierGid>
<ID>
<DomainName>XXXX</DomainName>
<Xid>LOAD DATE</Xid>
</ID>
</UnitQualifierGid>
<UnitValue>2/24/14</UnitValue>
</Unit>
<Unit>
<UnitQualifierGid>
<ID>
<DomainName>XXXX</DomainName>
<Xid>REFERENCE NUMBER</Xid>
</ID>
</UnitQualifierGid>
<UnitValue>98499</UnitValue>
</Unit>
What I need to get is the Unit/UnitValue value where the Unit/UnitQualifierID/ID/XID = LOAD DATE
I can't seem to figure how to get down into to see if its a Load Date, then back out to get the unitvalue.
thanks
|