XML Parse
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Mute
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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.
- Labels:
- Community
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Notify Moderator
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...
