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 #116: A Symphony of Parsing Tools!

Highlighted
8 - Asteroid

Hi! Here my solution :)

Highlighted
8 - Asteroid
now that was A LOT of RegEx for me! I'm also getting slightly different results - it seems I have a wider date range in my downloaded data
Highlighted
12 - Quasar
12 - Quasar

My solution! I was not matching back to the output as there were some cases it didn't match the input file. Program ID = 13642 is an example. The Piece IDs don't match fully to the XML. @ChristineB 

Spoiler
I had to do a lot of testing with the XML parse tools and continually copy and paste to look at the fields I wanted tot parse and ensure I was getting the correct results. Very tough challenge!
Challenge 116.PNG
Highlighted
14 - Magnetar
14 - Magnetar
Spoiler
Looks like I need to get on this XML Parsing train

Capture.PNG
Highlighted
Alteryx Partner
Spoiler
116. Data Parsing.PNG


I ignorantly didn't really understand the structure of xml and what the xml parse was really doing, so I only used one, and then tried to parse out the rest using regex and multirow formulas. I did think it must be easier (!) and so after finishing, I looked at the spoilers and used several xml parse tools as in the solution.
Highlighted
8 - Asteroid

My version.

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Good practice for XML parsing tool ... but I think, I'll never really like it.

Spoiler
13-08-_2019_17-36-01.png

 

Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Challenge 116 is done!

 

Spoiler
challenge 116 JMS solution.PNG
Highlighted
Alteryx Certified Partner

Not sure mine is the best way, but it works...

Spoiler
Challenge 116.PNG
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

@OllieClarke I think this is one of those times you need to put down the regex tool and try XML parsing. It's your Maslow's Hammer.