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!

Alteryx Certified Partner

This was very tough. Not an xml parsing fan.

 

Spoiler
Challenge 116 - Capture.PNGWorkflow
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
Highlighted
Asteroid

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

Fireball

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