I’m trying to learn how to read and iterate though XML data using .element and .attribute and then for each loops e.g trying things like ‘XMLData(my variable).Element(“data”).Element(“columns”).Attribute(“Age”).ToString’
but I’ve noticed the XML data is set up slightly differently to what I’ve seen in that it has columns information then records (as opposed to ‘just records’.) So I’m guessing I could reference the ‘desired column index’ to get the info I need but I’m not sure how to do this.
Appreciate it’s a big ask but could anybody please guide me on what I would write to get specific data like a persons first and last name or their country.
Thanks for the help,