How Can I Parse a Specific Child Element?

[hellyars]

This is a recurring nightmare for me.   My XML datasource re-uses element names over and over again.  I can't change this.

I want to target the "Cost" that is the direct child of ITEM.  I do NOT want the elements named "Cost" that are the grandchildren of Parent.    The actual dataset is more complicated.  I walk down to Parent using the Parse Tool with XML Element to Parse set to Specific Child Name: "Cost."  But, the Parse tool returns all the descendants of ITEM named "Cost", not just the child.   So, one row becomes 3 rows with the wrong sum.   Sum tool and Unique tools don't fix this.  

"ITEM"

• Hardware
  • Cost
    • Yr1
    • Yr2
    • Yr3
• Installation
  • Cost
    • Yr1
    • Yr2
    • Yr3
• COST
  • Yr1
  • Yr2
  • Yr3Can

[BenMoss]

Im sure the answer is yes but its extrnely hard to debug without some sample data; could you plwase share if possible?

Ben

[hellyars · Accepted solution]

I can work around this problem if I parse the root of the child and return its children and return the outer XML of the its children.