Challenge #283: The Summer Paralympic Games 2020

[Kaitlin-Sheehan]

Spoiler

Spoiler

[Sashikumar]

My Solution.

Spoiler

[ryan-bush]

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

[phottovy]

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

Spoiler

[daryll-maneja]

Spoiler

[balajilolla]

Spoiler

Solution Attached

[Michael_McKee]

Here it is.

Spoiler

 

[kelly_gilbert]

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

Example of #4 mismatch:

Spoiler

[Kamran1991]

My solution

[mikemotter]

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?