Challenge #189: Billboard Top 100

[lverce]

I don't think the solution is quite complete.  There are songs that have "Featured" or "And" designations that the solution doesn't contemplate.  

[Kirsten_Aleman]

I enjoyed participating in this challenge. Got to learn a few new tricks.

Spoiler

Spoiler

[SMSatCFA]

Not enough Johnny Cash; too much Mariah

LOL

[sachinw]

My Solution:

[DavidThorpe]

Approached this slightly differently to duplicating the workflow for the top10:

Spoiler

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:

[cstroh]

1st solution!

[Junya_Wang]

This is a very fun challenge. I had to look at the solution though

[laeorn]

Spoiler

Took a different approach from the solution, where featured artists are removed. Not all numbers are matched, but believe this is the right approach!