Important Community update: The process for changing your account details was updated on June 25th. Learn how this impacts your Community experience and the actions we suggest you take to secure your account here.

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
15 - Aurora
15 - Aurora

Done(header name slightly differs)

Spoiler
image.png
gawa
15 - Aurora
15 - Aurora

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