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

Highlighted
13 - Pulsar

Pretty quick challenge

Spoiler
Workflow 169.GIF

 

Highlighted
6 - Meteoroid
Spoiler
Spoiler Alert#169.JPG
Highlighted
10 - Fireball
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




 
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Nice one

 

 

Spoiler
Untitled.png



 

 

Highlighted
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

 

 

Highlighted
8 - Asteroid

Nice little challenge!

Highlighted
8 - Asteroid

My Solution

Highlighted
17 - Castor
17 - Castor

Fun one

 

England.jpg

 

Spoiler
wf.png

Dan

Highlighted
12 - Quasar

Decent enough way to start the day...

 

 

Highlighted
8 - Asteroid
Spoiler
image.png