Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
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 #138: World Series Wins

Highlighted
8 - Asteroid

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

9 - Comet

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

 

Spoiler
WC138.png
Highlighted
Alteryx Partner

My effort

Highlighted
7 - Meteor

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
17 - Castor
17 - 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
11 - Bolide
11 - 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!

Highlighted
Alteryx Partner

Solution attached.

Highlighted
8 - Asteroid

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

 

 

Spoiler
138.JPG
Highlighted
8 - 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
10 - 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".