community
cancel
Showing results for 
Search instead for 
Did you mean: 

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 #174: Appyhay Ondaymay!

Alteryx
Alteryx

Wow that was a bit of a battle. Tried to do it in the least tools possible!

 

Managed 4

 

Spoiler
Workflow.jpg
Struggled handling the double and single quotes in fields in the regex, so had to swap the single to Tilda to get my regex syntax to parse. Happy if anyone can advise on the escape character?
Alteryx Certified Partner
Alteryx Certified Partner

 

My solution. Translating "you" caused a little bit of confusion (solution says "youyay", but "ouyay" seems to conform to the Wikipedia rules).

 

Spoiler
06-08-_2019_12-20-31.png
Alteryx Certified Partner
Alteryx Certified Partner

It's been a while since I've solved a weekly challenge.  I may not have been as fast as @kat but I'm glad that I took the time to look at this problem.  @kelly_gilbert and I have a very similar solution (spoiler).  This was fun

 

Spoiler
capture.jpg

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and reboot. Order shall return.
Asteroid

My solution attached.

 

This one had RegEx written all over it, at least for me.  Ran into some issues trying to chain things together so I broke it up into individual words then split the processing whether the word started with a vowel or not.

Spoiler
174.png

My solution where I used mostly Formula tool.

Alteryx Certified Partner

Quod Erat Demonstrandum

 

Spoiler
Challenge 174 - Capture.pngRegex to the rescue
Asteroid
 
Bolide

Good RegEx practice. 

Spoiler
174.PNG174 workflow174 f.PNG174 formulas174 results.PNG174 results
Asteroid

Probably not the cleanest solution but it is identical!!!