Weekly Challenges

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

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

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA

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 Alumni (Retired)

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

phottovy
13 - Pulsar
13 - Pulsar

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 Alumni (Retired)

Here it is.

Spoiler
Capture.PNG

kelly_gilbert
13 - Pulsar

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
11 - Bolide

My solution

mmotte628
8 - Asteroid

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?