Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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 #278: Women Athletes and The Olympics

cguerra011
Atome

Solution

Laurap1228
Bolide

The third time ever that I've been able to 'Join By Position' 

KaneG
Alteryx Alumni (Retired)

I did some corrections for multiple country line items (doubles tennis) and for the Cincinnati Archers. And stayed away from Regex.

 

Révélation
KaneG_0-1628231848154.png

 

PammyC
Météore

My result

Qiu
21 - Polaris
21 - Polaris

Being late.

Révélation
challenge_278.PNG
doates003
Atome

 

Révélation
Challenge 278.PNG

 

 

apoorva_sharma
Météoroïde

Challenge Accepted!!

Jean-Balteryx
16 - Nebula
16 - Nebula

Here is my solution !

Divyaverma2906
Météore

Good

 

wigr
Atome

I have a couple of questions.

 

  1. In the solutions, It says e.g. that 11 women participated in the 1906 games, but in fact only 6 unique names participated. Shouldn't the solution then present 6 and not 11?
  2. In the solutions, it says e.g. that Aileen Muriel Riggin won Bronze in Diving and Silver in Swimming, but in fact it was the other way around. What would you consider best practice in this case - to drop the sport and just count the medals per type, athlete and games, or some other solution? There doesn't seem to be an ID which can ensure the right sport is matched to the right medal.

 

wigr_0-1628509747627.png