Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start 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 #138: World Series Wins

sean_bolte_dup_544
アステロイド

Nice throwing in pesky characters to get rid of.....

TylerNa
ファイアボール

Play ball! I'm pretty sure I over complicated this home run strategy.

 

スポイラ
WC138.png
richard_butler
メテオロイド

My effort

cbrettlockard
メテオール

Well, this certainly isn't the most efficient way to solve this challenge, but I got there.  I'm a little ashamed of how many tools I used, but I'll post a screen shot anyway.  Feel free to make fun of me!

 

スポイラ
WC138.PNG
danilang
19 - Altair
19 - Altair

@cbrettlockard

 

You might win the prize for most tools used in a solution...ever :)  But like the pilots say "Any landing you can walk away from, is a good one"

 

Dan

ggruccio
ACE Emeritus
ACE Emeritus

Started down the path of win percentage based on number of games instead of number of appearances.  Which was interesting due to the ties, but then figured out what you were looking for!

jezknee
メテオール

Solution attached.

KevinW
アステロイド

Not the most elegant solution, but it gives the correct output.

 

 

スポイラ
138.JPG
ZenonH
アステロイド

Just like every other weekly challenge  this looked to be easier than it turned out to be. I think I might have the longest solution, but like every other solution it works. 

スポイラ
Workflow Solution.PNG

 

cgoodman3
14 - Magnetar
14 - Magnetar
スポイラ
Solved, but took far too long as I was trying to get the Crew Expect Equal tool to work and it kept returning an error as the team names weren't matching. It looked like there was trailing white space but that didn't remove it and ended up removing an unknown character with a few string functions.

challenge_138.JPG

I'm interested in the regex solutions as hopefully they won't bring through the additional "white space".
Chris
Check out my collaboration with fellow ACE Joshua Burkhow at AlterTricks.com