Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
Community is experiencing an influx of spam. As we work toward a solution, please use the 'Notify Moderator' option on the ellipsis menu to flag inappropriate posts.

Weekly Challenges

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

Challenge #37: Parsing a Raw XML File

LandonG
8 - Asteroid

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

jasperlch
12 - Quasar

Solution attached.

msicak
8 - Asteroid

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
jamielaird
14 - Magnetar

Here's my solution.

 

Spoiler
nav_overview.png
Waynemk
8 - Asteroid

and another

dsmdavid
11 - Bolide

Branches and more Branches

Spoiler
37.png
JosephSerpis
17 - Castor
17 - Castor

Challenge Completed

KOBoyle
11 - Bolide

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

CHarrison
8 - Asteroid

Good introduction to XML parsing 🙂

asabau
8 - Asteroid

Here it is!