This is an extract from a government xml budget document I am trying to parse. It is publicly available
I have run into this problem before. But, I am deeper into the data and the prior solution is not available
I have attached both a snippet from the XML and a simplified workflow that depicts my challenge.
The master element is ModificationItems. I need to extract data located on 3 lines:
But there is a problem. Total Cost is used multiple times throughout. I specifically want only the Total Cost that appears under Total Cost. I want to ignore the other total Cost items. While others look the same, I need specifically this one.
I tried to walk it down from Procurement to Total Cost to Total Cost to ignore the other Total Cost Items under other children of Procurement. It is not working. As you can see, I am getting multiple row outputs. It should be one row.
Help and thank you
Solved! Go to Solution.
Looking at your example, it seems it was a simple fix. Many thanks.