Challenge #116: A Symphony of Parsing Tools!

[mgaronson]

Spoiler

Big thanks to @joe_yang solution that helped me understand how to parse XML.

[kristiadiuisan]

Spoiler

[alacoume]

A solution:

[bkclaw113]

Reminds me why I hate working with XML

Spoiler

[chandler-gjino]

attaching my solution

[geoff_zath]

Spoiler

[michaelbono16]

Image

[mithily]

Spoiler

followed mmongeons lead but will have to revisit as its not as clean as it can be

[ed_hayter]

Very challenging.

This exposed my lack of knowledge of XML tool but I think also exposed its flaws. WIthout knowing smart configurations to do this in simple terms I set about working through the levels of the XML - tokenizing where required with REGEX.

End result was a lot more records than the expected output. In part because I seemed to capture more information for one concert that had 1 row in the expected output mine had over 7 rows as I captured all the songs played at that concert. But even my method seemed to miss 14 concerts I could not get any information for.

Next steps - need to crack the config for xml parse.

Spoiler

I also learnt that copying across the download field is not sustainable it leads to slow computing as the table becomes huge holding that large a string field.

[olga_strubbe]

Thank you, @ChristineB!  My Download tool is blocked by the firewall, but I followed your solution with the data from Download tool, using XML Parse tool.  This was my first time using XML Parsing tool.  Thank you for showing the way!