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"
Solved! Go to 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.