cancel
Showing results for
Did you mean:
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

## Challenge #169: Women's World Cup Wins

Comet

Pretty quick challenge

Spoiler

Atom
Spoiler
Asteroid
Spoiler
I like how the input data is a separate file as it:
1) checks users know how to read in different delimited files
2) As users are likely to save the input file to the same location as the workflow then it makes viewing other people's solutions a bit easier compared to when the files are packaged up.

Here's my solution:

Alteryx Partner

Nice one

Spoiler

Alteryx Partner

I do love the weekly challenges, and here is my solution

Spoiler
This is a nice "beginner" task, since you will need to import the CSV file yourself.

Meaning, finding the right tool and the import a ANSI file that has tab as delimiter (\t).
Settings

I am not sure if it is "cheating" to use the Formula tool, but the winner can be determined using a formula like this:

``Winner = IF [score_i]>[score_j] THEN [Team_i] ELSEIF [score_i]<[score_j] THEN [Team_j] ELSE Null() ENDIF``

The is was just a matter on do a Count NonNull's on the result, sort and pick the fist record

Workflow

That is how I matched the provided result

Result

Still Climbing

/Verakso

Asteroid

Nice little challenge!

Asteroid

My Solution

Aurora

Fun one

Spoiler

Dan

Quasar

Decent enough way to start the day...

Meteor
Spoiler