Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #37: Parsing a Raw XML File

Highlighted
8 - Asteroid
 
Highlighted
8 - Asteroid

Done!

Highlighted
8 - Asteroid
 
Highlighted
8 - Asteroid
 
Highlighted
7 - Meteor

my attempt - first time using this tool

Highlighted
8 - Asteroid
 
Highlighted
Alteryx Certified Partner

Well, that was fiddly but I got there. Every time I parse XML I feel like I'm getting into an inception situation...

 

Spoiler
Workflow:

mceleavey_0-1582893401713.png

Parsed the root from the top level XML field, then parsed the root and child from the billing and shipping sections. Dropped unwanted fields, dynamically renamed to provide the prefix and smooshed them back together using the multi-join tool.

Pro tip: When you want to ensure you have all the required columns and have them in the same order, put a select tool on the result, un-check the "unknown" box, then copy and paste that onto your output. This will show you the missing columns and will put the columns in order.

M.

Highlighted
8 - Asteroid
 
Highlighted
8 - Asteroid

Solution attached.

 

Spoiler
MP37.png
Highlighted
8 - Asteroid

This was super helpful in understanding how the XML Parse tool works - will definitely make me less likely to run away from any XML tasks in the future!