community
cancel
Showing results for 
Search instead for 
Did you mean: 

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #116: A Symphony of Parsing Tools!

Alteryx Certified Partner

This was very tough. Not an xml parsing fan.

 

Spoiler
Challenge 116 - Capture.PNGWorkflow
Highlighted
Asteroid

First time using the XML Parse tool.  had fun figuring out what settings to use for each section, but ended up pretty streamline compared to other solutions I'm seeing.

 

Spoiler
Challenge_116_Spoiler.JPG
Bolide

Cheers!

Asteroid

Here is my solution

Alteryx Certified Partner

My solution

Alteryx Certified Partner

Here's my solution. Cache came in handy here.

 

Spoiler
Screenshot 2018-12-28 at 22.41.27.pngScreenshot 2018-12-28 at 22.41.33.png
Asteroid

This was tough but very useful exercise.

My solution attached.

Alteryx Certified Partner

My solution :)

Spoiler
challenge_116.PNG
Asteroid

My solution. I don't think it is a beautiful one...

Whew, this one was a workout! Good practice configuring parsing tools!

 

Spoiler

The solution retains only the first performance of each program (for example, the solution contains the 9/7/2011 performance of program 11640, but not the 9/8/2011 performance).
I parsed all concerts, but filtered out all but the first.

The given solution removes first intermissions, but not all intermissions (for example, Program ID = 12104 and Piece ID = 7955*.
I removed all intermissions.

The given solution converts the soloist list to V_String (rather than V_WString), so some special characters are lost (example: Program ID = 13872, Piece ID = 2663*).
I used a V_WString field type to retain the special characters.

Spoiler

challenge_116_workflow1.PNG


challenge_116_workflow2.PNG