XML Parsing Auto Detect Child

[JoshKushner]

When using the 'Auto Detect Child' function in the XML Parsing Tool it doesn't get all children. Has anyone else seen this or resolved this issue?

As a workaround I've programmed my XML parsing to target specific tags that I know will be there and then return the child values (returning child values works 100% fine)

Thank you for your help!

Doesn't 100% Work:

100% Works:

[dataMack · Accepted solution]

In choosing Auto-Detect Child, Alteryx will try to pick the child element it thinks is relevant- it won't return all child elements.  When I have to do XML parsing (or HTML parsing using the XML parse tool), I'll usually have the XML document open on my other monitor in a tool like Sublime so I can easily browse through it and find the elements I want in the structure, then setup multiple, or a series of, XML parse tools in Alteryx, specifying the child element.  Make sure to check the 'Return Outer XML' if you want to to serial parsing and get to deeper child elements on subsequent XML parse tools. 

[JoshKushner]

Ah! Then the XML parser is doing exactly what it needs to. That makes sense.

Thank you!