Free Trial

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.

SUBMIT YOUR IDEA

Challenge #169: Women's World Cup Wins

T_Willins
14 - Magnetar
14 - Magnetar

Pretty quick challenge

Révélation
Workflow 169.GIF

 

leena_suva
Météoroïde
Révélation
Spoiler Alert#169.JPG
cgoodman3
14 - Magnetar
14 - Magnetar
Révélation
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 🙂

 

 

Révélation
Untitled.png



 

 

Verakso
Bolide

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

Révélation
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
Astéroïde

Nice little challenge!

wwatson
Quasar

My Solution

danilang
19 - Altair
19 - Altair

Fun one

 

England.jpg

 

Révélation
wf.png

Dan

neilgallen
Quasar

Decent enough way to start the day...

 

 

badiualex
Astéroïde
Révélation
image.png