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

kunderwood
8 - Asteroid
Spoiler
kunderwood_0-1630331722685.png

 

alexnajm
16 - Nebula
16 - Nebula

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
20 - Arcturus
Spoiler
binuacs_0-1630335914505.png

 

Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
Maskell_Rascal_0-1630336209331.png

 

Cheers!

Phil

binuacs
20 - Arcturus

left(ToString([RecordID]),3)

binay2448
11 - Bolide

My Solution attached ..

Tony_Castillo
9 - Comet
Spoiler
Tony_Castillo_0-1630336857314.png