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.
We'll be completing standard maintenance for our Single Sign-On system on November 30th 6pm Pacific Time for approximately one hour. During this time My Alteryx and sign-in functionality to all My Alteryx programs (Licensing Portal, Community, Beta Program, Case Portal, and others) may be inaccessible. Thank you for your patience.

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
8 - Asteroid
Spoiler
kunderwood_0-1630331722685.png

 

alexnajm
10 - Fireball

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
9 - Comet

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
17 - Castor
Spoiler
binuacs_0-1630335914505.png

 

Maskell_Rascal
13 - Pulsar

Here is my solution!

 

Spoiler
Maskell_Rascal_0-1630336209331.png

 

Cheers!

Phil

binuacs
17 - Castor

left(ToString([RecordID]),3)

binay2448
11 - Bolide

My Solution attached ..

Tony_Castillo
9 - Comet
Spoiler
Tony_Castillo_0-1630336857314.png