Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAMy solution for challenge #116.
My final output is around 6k rows for concerts from 2011-2017. Also I think the data has changed based on the comparison between the suggested solution and my solution. Now there are more concert dates whilst some concert dates have changed altogether.
Does anybody else have the same issue or maybe can you find if I am missing something?
Also found more records as others did which includes all of 2011 which solution answer did not. Happy with my final output.
Certainly qualifies as a challenge. I highly recommend you sample the data after downloading to make building it out less painful.
My Solution.
Great challenge. I opted not to use the XML Parse tool, which gave me a slightly more complex workflow but with the advantage of a 2 second runtime. When I tried to run the flows people built using XML Parse it was taking forever, so I gave up. Not sure if that's just my machine but they seemed to create 50GB+ of data. Like others, I couldn't exactly replicate the answers but I went for just the first performance (and no interval) to get as close as I could
I am not a huge fan of XML parsing tool, but this challenge was heaps fun!