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

kunderwood
7 - Meteor
Spoiler
kunderwood_0-1630331722685.png

 

alexnajm
8 - Asteroid

A little extra work to match the output 1 to 1, otherwise very easy!

Spoiler
challenge_283_start_file_Alex Abi-Najm.PNG
Toons
12 - Quasar

My solution :

 

Spoiler
Toons_0-1630332520856.png

 

dYoast
8 - Asteroid

My results for the countries and disciplines are different for the athlete IDs.

Spoiler
dYoast_0-1630332636969.png

 

jpl5253
6 - Meteoroid
Spoiler
Spoiler

My solution - I could not get the Athlete IDs to line up compared to what was provided in the example output, as the example has repeating Athlete IDs whereas the source data does not. However, my output contains the same number of records with all else the same except for the actual IDs.

binuacs
8 - Asteroid
Spoiler
binuacs_0-1630335914505.png

 

Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
Maskell_Rascal_0-1630336209331.png

 

Cheers!

Phil

binuacs
8 - Asteroid

left(ToString([RecordID]),3)

binay2448
11 - Bolide

My Solution attached ..

Tony_Castillo
8 - Asteroid
Spoiler
Tony_Castillo_0-1630336857314.png