Join the Alteryx Community’s Maveryx Summer Cup event! Compete, network with others, and earn your gold through a series of challenges from July 24th to August 11th. Learn more about the event here.
alteryx Community

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.

Challenge #169: Women's World Cup Wins

14 - Magnetar

Pretty quick challenge

Spoiler

6 - Meteoroid
Spoiler
14 - Magnetar
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:

Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
16 - Nebula

Nice one 🙂

Spoiler

11 - Bolide

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

8 - Asteroid

Nice little challenge!

12 - Quasar

My Solution

19 - Altair

Fun one

Spoiler

Dan

12 - Quasar

Decent enough way to start the day...

8 - Asteroid
Spoiler