Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #189: Billboard Top 100

Highlighted
 
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Long live the sample tool.

 

Spoiler
BenMoss_0-1580742039714.png
Highlighted
Atom

I enjoyed this weekly challenge and it was interesting to see some of the names on there.

 

I also used a data cleansing tool to Title Case the Artists names. With the Output provided in the workflow, I didn't like how the sort worked with the 00's, 10's, etc. so I kept the full 4 digit year on there (1960's, 1970's, etc).

Highlighted
Alteryx Partner

My solution

Spoiler
dsmdavid_0-1580980409420.png
Highlighted
Meteoroid
 
Highlighted
Spoiler
Angela_M_Burks_0-1581376685975.png
Highlighted
Meteor