The Summer Cup has officially kicked off! Get ready to learn, connect, and compete! Complete Community engagement tasks to earn points and unlock exclusive Summer Cup badges for your profile. 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

kunderwood
8 - Asteroid
Spoiler
kunderwood_0-1630331722685.png

 

alexnajm
18 - Pollux
18 - Pollux

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

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

Spoiler
dYoast_0-1630332636969.png

 

jpl5253
7 - Meteor
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
21 - Polaris
Spoiler
binuacs_0-1630335914505.png

 

Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
Maskell_Rascal_0-1630336209331.png

 

Cheers!

Phil

binuacs
21 - Polaris

left(ToString([RecordID]),3)

binay2448
11 - Bolide

My Solution attached ..

Tony_Castillo
10 - Fireball
Spoiler
Tony_Castillo_0-1630336857314.png