I am reading the complex XML file. I am getting one field in multiple node. How to read it.
In one node, StoreID is coming at Event/Node/StoreID
in another node its like Event/Node/Tender/StoreId
like wise I am getting StoreId at different level.
How to write the XPath query to read StoreID?
You can do it in two steps with tExtractXMLField component :
- 1st component : loop = Event/Node/Tender/StoreId
- 2nd component : loop = Event/Node/StoreID
Then you can merge the results tables with tUnite.