Want to get involved? We're always looking for ideas and content for Weekly Challenges.
SUBMIT YOUR IDEAA little extra work to match the output 1 to 1, otherwise very easy!
My results for the countries and disciplines are different for the athlete IDs.
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.
left(ToString([RecordID]),3)