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 · Accepted solution]

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.

[Harbinger]

This should get you what you need! 

[akanaka]

Thanks so much @morr-co, this is amazing!

Making some slight changes based on this but this seems to be what I'm looking for. Really appreciate it!

[akanaka]

@Harbinger, thanks so much for your help as well!

I might be running your flow incorrectly - when I put a "Browse" on your last "Union" button, I'm only getting a few rows of data from the very top of the document. This is super useful though! Thanks!