Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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

jon_amanrich
8 - Asteroid

Nice challenge, parsing XML can come in handy!

gawa
16 - Nebula
16 - Nebula

Done(header name slightly differs)

Spoiler
image.png
gawa
16 - Nebula
16 - Nebula

My solution

myastarling
10 - Fireball

I solved this two ways - one with several XML parse tools, another with a text-to-columns and regex parse.

SJKIM
8 - Asteroid

Does anyone know how to easily compare the answers to see if they are correct?

caltang
17 - Castor
17 - Castor

Done!

 

Spoiler
image.png
Could have used Dynamic Rename, but decided to just write it out lol...
Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
Computernerd
8 - Asteroid

My solution is WAY different than the proposed, but it works. 

SGolnik
11 - Bolide
11 - Bolide

I attempted to use the XML tool, but decided regex worked better.

afnfyz
8 - Asteroid

Used the XML parse tool for the first time. Also got in the think of it with the multi row formulas.
T'was fun.

Spoiler
Screenshot 2023-10-24 144934.png
DanielG
12 - Quasar

Solved