Challenge #169: Women's World Cup Wins

A solution to last week's challenge can be found here.

Using the values in the attached file "womens_world_cup_data.txt", determine which team won the most matches.

Go Team USA!

womens_world_cup_data.txt

challenge_169_start_file.yxmd

challenge_169_solution.yxzp

Join

Preparation

Data Analysis

Data Preparation

Transform

Basic

Foundation

Accepted answers

All comments

Solution attached.

challenge_164_complete.yxmd

Spoiler

challenge_169_AP_ver.yxzp

My Solution

challenge_169_start_file.yxmd

Solved

challenge_169_start_file.yxmd

Seems like there would be a simpler way to do this, but it only took me a couple of minutes.

Spoiler

Screenshot 2024-01-30 153946.jpg

challenge_169_tbrown.yxmd

🙂

challenge_169_start_file_CB.yxmd

challenge_169_solved.yxmd

This one surprised me!

challenge_169_solution.yxzp

Please see attached!

challenge_169_solution CNguyen.yxmd

james_western_HUN

Another easy one

Spoiler

Since ties didn't matter I made a simple formula to track if i won or j won. I split the workflow into two streams to summarize i wins and j wins by country, unioned the streams together, then it was a simple sort and sample to achieve the desired output.

challenge_169_start_file_jtw.yxmd

Completed-BG

challenge_169_start_file.yxmd

Spoiler

challenge_169_GKZ.yxmd

Importing text files and counting rows

Challenge_169.yxmd

Spoiler

challenge_169_volha.yxmd

#Solution

challenge_169_start_file.yxmd

Looks like I had the wrong file uploaded.

Spoiler

Screenshot 2024-03-26 161907.png

challenge_169_complete.yxmd

Solution

challenge_169_start_file.yxmd

My Solution

challenge_169.yxzp

beatriz_alteryx06

Challenge solved

Deafio 169.yxzp

Quick Practice! Great starter challenge.

challenge_169_solution_lw.yxmd

I did mine a little different but got the result!

challenge_169_start_file.yxmd

Hi All,

Please find my Solution.

challenge_169_start_file_Shuresh_Solution.yxmd

Spoiler

Argh those cheeky ties nearly caught me out!

Weekly Challenge 169 30-04-24.yxzp

Probably not the most elegant solution but the output is correct.

Spoiler

Having looked through other replies i'm surprised how many people didn't realise or notice that a draw was a possible outcome

challenge_169_my_solution.yxmd

Hi,

Fun challenge used the formula tool to Determine the winner, summarise to count and sort tool to sort and sample 1

Spoiler

Challenge 169 Workflow Pic.jpg

Straightforward challenge. Woot England!

challenge_169_Complete MGA.yxzp

done

challenge_169_BE.yxmd

Awesome

challenge_169.yxmd

Solution

TejasviMayekarchallenge_169_Solution.yxmd

Solution attached

challenge_169_start_file.yxmd

Solution attached

challenge_169_VizWithDan.yxmd

Quick Links

Tags

This months top contributors

atcodedog05 19458

Qiu 15866

MarqueeCrew 13708

apathetichell 13703