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

deepaprash
8 - Asteroid

Solved!

Normster
8 - Asteroid

Wow!  My solution looks very different from everyone else's.  Even though I used fewer tools, it seems like I did a lot of organization and clean up manually.

 

Normster

Spoiler
Normster_0-1593976591281.png

 

attilajozsefhegedus
7 - Meteor

Jack Lumber

Blake
12 - Quasar

XML parsing != fun 

 

Spoiler
37.png
Ben_Jeffreys
8 - Asteroid

My submission

FlorianC
Alteryx
Alteryx

XML might seem complex at first glance but at least it is structured. Breaking down the workflow into different steps makes it easy to understand the process.

 

Spoiler
WorkflowWorkflow
Florian Carrier
Strategic Solution Consultant
Alteryx
treepruner
9 - Comet

I used the xml parser, but it took 6 to get all the fields. Not sure I did it the most efficient way.

JethroChen
10 - Fireball
Spoiler
challenge_37_jc.PNG
KilianL
Alteryx Alumni (Retired)

I tried a different approach using the 'Parse XML' Macro, you can find it here: https://gallery.alteryx.com/#!app/Parse-XML/584b5589f499c704689e363b

 

Spoiler
037 - Parse XML with Macro - Kilian.png
JoePC
9 - Comet

Solution Attached