Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #138: World Series Wins

Highlighted
Asteroid

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

Highlighted
Comet

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

 

Spoiler
WC138.png
Highlighted
Alteryx Partner

My effort

Highlighted

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!

 

Spoiler
WC138.PNG
Highlighted
Castor
Castor

@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

Highlighted
Bolide
Bolide

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!

Alteryx Partner

Solution attached.

Highlighted
Asteroid

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

 

 

Spoiler
138.JPG
Highlighted
Asteroid

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. 

Spoiler
Workflow Solution.PNG

 

Highlighted
Fireball
Spoiler
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".