This XML is of an online form, in which a user can enter data for up to 5 different markets, and add any number of SKUs associated with each market (in this example the user has chosen 2 markets, 3 SKUs for the 1st market and 2 SKUs for the 2nd). I need to read all the data from this XML by market - how do I read the SKU data per market?
For all the other (non-SKU) fields I'm using different XPath queries - e.g. //Market - to return all the e.g. Market data and move into a collection, then return all the e.g. Retail data and move into a collection etc., and I know that the collection data at index 0 is from the 1st form section - i.e. 1st Market, index 1 is from the 2nd, etc. But I don't know how to say, "give me all the SKUs that are in the 1st form section/ 1st Item/ 1st Market, then give me all the SKUs that are in the 2nd form section/ 2nd Item/ 2nd Market, etc. |