XML Parse

[karlynlarson]

I am trying to parse XML code in Alteryx. I've successfully accomplished this with a few files but for other files not all the data from the file will come into the input tool in Alteryx. This happens when I make the data type XML, but if I input it as a CSV all the data comes in. I would like to bring it in as an XML. This issue is coming from the very beginning and not an issue with the XML parse tool itself.

For example, if I had a file with 30 parent nodes only 2 will come in even though it is all following the same formatting.

[acarter881]

Hello, @karlynlarson.

Without testing some examples myself, I'm not sure what the solution would be. However, I've found Python to be a robust solution for parsing XML, as there are libraries built for the sole purpose of parsing XML.

My example solution from a Weekly Challenge shows how I used Python to parse XML: https://community.alteryx.com/t5/Weekly-Challenge/Challenge-116-A-Symphony-of-Parsing-Tools/m-p/1016...