Weekly Challenge

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

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

Submit Feedback
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 #121: World Cup 2018!

Highlighted
8 - Asteroid
Spoiler
solution.JPG

Highlighted
Alteryx Partner
Spoiler
121.PNG
Highlighted
Alteryx Partner

I'm working on my Regular Expressions.
So I did this challenge and did not use the Split tool at all - all RegEx.

I also used the new to 2020.2 release the Cleanse Tool ability to remove Null rows.

Very FUN!

Challenge_121_RegEX.png

 

 

Highlighted
6 - Meteoroid

Probably the longest workflow on this thread ! So much yet to learn

Spoiler
lnihaalWC121Solution.PNG
Highlighted
6 - Meteoroid

Hi,

 

The solution file is attached, Please review and comment

Highlighted
Alteryx Partner

Now seems as good a time as any to reiterate that I am not technical. 

 

Note that I have not cleaned this workflow up in any way - instead, it stands as a reminder that there are more ways that one to skin a cat and practice makes perfect.

 

Warning: do not click on this spoiler if inefficiency is a trigger for you!

Spoiler
Shifty_0-1594576605869.png

 

Highlighted
Alteryx Certified Partner

@Shifty if you got the right answer then you nailed it.

 

M.

Highlighted
Alteryx Partner

Oh yea, I got it correct.  

I love RegEx!!!!

 

Thanks for the feedback.

Highlighted
8 - Asteroid

.

Highlighted
7 - Meteor
Spoiler
Solution.jpg