Want to get involved? We're always looking for ideas and content for Weekly Challenges.
I don't think the solution is quite complete. There are songs that have "Featured" or "And" designations that the solution doesn't contemplate.
I enjoyed participating in this challenge. Got to learn a few new tricks.
Not enough Johnny Cash; too much Mariah
Approached this slightly differently to duplicating the workflow for the top10:
Unioned the data at the start with a top10/top100 flag then ran through one process, using a cross-tab to create one output table:
This is a very fun challenge. I had to look at the solution though