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.

Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

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

Submit Feedback

Challenge #169: Women's World Cup Wins

T_Willins
14 - Magnetar
14 - Magnetar

Pretty quick challenge

Spoiler
Workflow 169.GIF

 

leena_suva
6 - Meteoroid
Spoiler
Spoiler Alert#169.JPG
cgoodman3
13 - Pulsar
13 - Pulsar
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




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

Nice one 🙂

 

 

Spoiler
Untitled.png



 

 

Verakso
10 - Fireball

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

 

 

pasccout
8 - Asteroid

Nice little challenge!

wwatson
12 - Quasar

My Solution

danilang
18 - Pollux
18 - Pollux

Fun one

 

England.jpg

 

Spoiler
wf.png

Dan

neilgallen
12 - Quasar

Decent enough way to start the day...

 

 

badiualex
8 - Asteroid
Spoiler
image.png