Parse XML Government XML File

akanaka

Hello everyone!

I'm trying to parse an XML file created by CMS. 

https://www.federalregister.gov/documents/full_text/xml/2020/05/01/2020-05050.xml

Ideally, I'd like to create one column with headers (indicated by the 'HD' Tag) and another columns with the details (usually indicated by the 'P' tag).

I'm very new to XML, and am having trouble parsing this. When I try to take the HD fields, the information under the 'P' tags do not populate, even when using the XML Parse tool. I believe it's because the 'P' sections are not child values under 'HD' tags, however, I am unsure if there's a way to get around this. 

I'd appreciate any suggestions you have! Thanks!

morr-co

Hi @akanaka - attached is an attempt at this. I found it more useful to first split the XML to rows, then use the XML parse tool. I wasn't sure what your desired output was so the summarization could obviously be changed.

parse_xml.yxmd