Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #169: Women's World Cup Wins

13 - Pulsar
13 - Pulsar

Pretty quick challenge

Spoiler
Workflow 169.GIF

 

6 - Meteoroid
Spoiler
Spoiler Alert#169.JPG
12 - Quasar
12 - Quasar
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:

challenge 169.PNG




 
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com
Alteryx Certified Partner
Alteryx Certified Partner

Nice one 🙂

 

 

Spoiler
Untitled.png



 

 

Alteryx Certified 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).
SettingsSettings

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

WorkflowWorkflow

 



That is how I matched the provided result

ResultResult

Still Climbing

/Verakso

 

 

8 - Asteroid

Nice little challenge!

12 - Quasar

My Solution

17 - Castor
17 - Castor

Fun one

 

England.jpg

 

Spoiler
wf.png

Dan

12 - Quasar

Decent enough way to start the day...

 

 

8 - Asteroid
Spoiler
image.png