Weekly Challenge

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

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #37: Parsing a Raw XML File

Highlighted
Alteryx Certified Partner

I hope I parsed this test...

 

Spoiler
nav_overview.png
Highlighted
Alteryx Certified Partner

Solution attached

Highlighted
8 - Asteroid

Without taking a peak at anyone's work, I was able to come up with the same results. Here is my approach.

Highlighted
16 - Nebula
16 - Nebula

I guess I use macros too often

Spoiler
I built a simple macro to wrap around James Omnibus XML Input tool which automatically parses out XML
Capture.PNG
Highlighted
Alteryx Certified Partner

We did this challenge a while ago at the Data School class, and I still don't like HTML parsing

Spoiler
nav_overview.png
Highlighted
16 - Nebula
16 - Nebula

Hey @Natasha,

 

I'm in full agreement with you about HTML parsing being a bit undeveloped at the moment.

If you have any ideas about how the product team could close this gap - drop them under the "Ideas" section - they do read these, and if the idea is well supported by the community it has a good chance of making it into the product.

Highlighted
12 - Quasar

I mean the columns are out of order, but the content is there

Highlighted
10 - Fireball

First time using the alteryx xml parser. It was a little humbling

Highlighted
12 - Quasar
12 - Quasar

Same here.  First time using xml parse.  Lot of trial and error (mostly error).  Makes sense now!

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

I find parsing XML really tedious to parse. It takes me ages to get the right tag name. Eventually found two solutions that are both different to the more linear official solution give. My solution attached.

 

Spoiler
challenge_37 - Snip.PNG