Challenge #116: A Symphony of Parsing Tools!

[patrick_digan]

Spoiler

I made use of @jdunkerley79's XMLInput which I previously wrapped into a generic macro so it could get the xml all parsed. I like working with it because it gets to the most granular level and breaks everything out. I split the needed fields into 3 different buckets based upon what level of the xml they're at and whether i need to take the first entry or concatenate them.

[joe_yang]

My End Goal was one pipeline that is simple and easy to understand without too many joins, prepping, and transforming since the input data is in a nice and clean flat file.

[patrick_digan]

@Natasha @joe_yang It's impressive how you were able to use so few tools....

[AdityaSardeshpande]

I noticed that in the expected output, only 1 concert info was read per program ID.

I however have read first 2 concert info and as  such have more rows than expected.

*This is the first time , I am using XML parse and would appreciate your feedback.

[MMehdi]

Challenge 116 done

Spoiler

Workflow - challenge #116

[joe_yang]

I think Aditya has a good point here because one Program can have many showings of the same concert which can land on different days and times.  If the Times and Dates of these showings are important to the case, I've gone ahead and corrected my workflow to include the additional showings:

[GalynaSkamrova]

My Solution

Spoiler

[AdityaSardeshpande]

Thank you joe_yang !

[KevinW]

Hi,

I got the data to match except for program ID 12104 piece 7955* - if you look at the interval information this is the second intermission - not sure why it has a piece ID in the XML.  my data did not have this line as I stripped out the intermissions but the output does.

[NicoleJohnson]

My solution!

Spoiler

Got a little picky on this one with the summarization of composers, conductors, soloists, works & movements - I didn't want to see the same one listed twice in the details if that program had more than 1 of the same work/person. So my results probably don't match exactly, but a cursory review looks pretty decent!

Cheers!

NJ