Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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
Alteryx

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?