community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #37: Parsing a Raw XML File

Alteryx Certified Partner

I hope I parsed this test...

 

Spoiler
nav_overview.png
Alteryx Certified Partner

Solution attached

Asteroid

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

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
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
Nebula
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.

Bolide

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

Fireball

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

Bolide
Bolide

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

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