Free Trial

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!