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

First Weekly Challenge that I have posted.

 

Since learnt that it's more simple to concatenate the artists with the Summarise tool...

 

John

 

 

Spoiler
Spoiler.PNG

 

Highlighted
Meteor

Enjoyed this one! And learned that I could modify the delimiters when I concatenate in the Summarize tool...

Highlighted
Meteor
Spoiler
kylemhabe_0-1573667579053.png
Highlighted

 

 

Solution.JPG

 Little late to the party, but bringing forward my solution!

Highlighted
Asteroid

Hi! Here my solution

Highlighted
Meteor

Here's my Workflow

Highlighted
Asteroid

Nice and short challenge this week!

 

Spoiler
Capture.PNG
Highlighted
Alteryx
Alteryx

Solved it without any joins like most solutions I peeked at afterward

 

Spoiler
RobertW_0-1573685418981.png
Highlighted
Alteryx Partner

My answer

Highlighted
Alteryx
Alteryx

@jmt214 There are a few with "Ties" your solution doesn't quite match on