We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #283: The Summer Paralympic Games 2020

Kaitlin-Sheehan
Alteryx
Alteryx
Spoiler
Spoiler
Challenge 283.png
Sashikumar
8 - Asteroid

My Solution.

Spoiler
ch283.PNGch283_1.PNGch283_2.PNGch283_3.PNG
ryan-bush
Alteryx
Alteryx

Unsure why we'd get rid of RecordID characters but nonetheless, fun challenge!

phottovy
12 - Quasar

Good example to use the underutilized "Concatenate" option in the summarize tool. 

 

Spoiler

283.png

 

 

daryll-maneja
6 - Meteoroid
Spoiler
Capture.PNG
balajilolla
8 - Asteroid
Spoiler
Solution Attached

balajilolla_0-1630343591148.png

 

Michael_McKee
Alteryx
Alteryx

Here it is.

Spoiler
Capture.PNG

kelly_gilbert
12 - Quasar

These summarization challenges are great, because they remind me of different ways to solve the "top 5" types of questions!

 

As of 8/30/2021 2:00 PM, I think the provided solution may have cut off some of the digits in part #4 (where the RecordID was > 3 digits (or maybe I misunderstood the ask!)

 

Worlfkow:

Spoiler
kelly_gilbert_0-1630346629397.png

 

Example of #4 mismatch:

Spoiler
kelly_gilbert_1-1630346883373.png

 

Kamran1991
8 - Asteroid

My solution

mmotte628
5 - Atom

I feel like I did not get the last one right, as the athlete IDs there do not match the ones in the output. However, they do match the IDs when I examined them earlier in the workflow to check on them. Can anyone see that?