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.
Getting started with Designer? | Start your journey with our new Learning Path!

Challenge #116: A Symphony of Parsing Tools!

Asteroid

Hi! Here my solution :)

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
Bolide

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
Pulsar
Pulsar
Spoiler
Looks like I need to get on this XML Parsing train

Capture.PNG
Alteryx Certified 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.

My version.

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 Partner

Challenge 116 is done!

 

Spoiler
challenge 116 JMS solution.PNG
Alteryx Partner

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

Spoiler
Challenge 116.PNG
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.