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

Did not use the XML Parsing tool for this...pretty painful experience!

Highlighted
12 - Quasar

Solution attached.

Highlighted
Alteryx Certified Partner

Like others before me I branched the parse tool into 4 streams, among other reasons to keep my sanity in the face of outerXML column names (and keeping the solution dynamic, too).

 

Spoiler
challenge37.png
Highlighted
Alteryx Certified Partner

Here's my solution.

 

Spoiler
nav_overview.png
Highlighted
8 - Asteroid

and another

Highlighted
Alteryx Partner

Branches and more Branches

Spoiler
37.png
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Challenge Completed

Highlighted
Alteryx Certified Partner

Solution attached. I took the linear approach with an intermediate step for field renaming/removal. While requires more steps, the branching approach is definitely more readable.

 

-Ken

Highlighted
8 - Asteroid

Good introduction to XML parsing

Highlighted
Alteryx Certified Partner

Here it is!