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

JoeS
Alteryx Alumni (Retired)

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

 

Managed 4

 

スポイラ
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?
RolandSchubert
16 - Nebula
16 - Nebula

 

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

 

スポイラ
06-08-_2019_12-20-31.png
MarqueeCrew
20 - Arcturus
20 - Arcturus

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 🙂

 

スポイラ
capture.jpg

Cheers,

 

Mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
hbraunius
アステロイド

My solution attached.

 

David-Carnes
クエーサー

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.

スポイラ
174.png
piotrzawistowski
アステロイド

My solution where I used mostly Formula tool.

PhilipMannering
16 - Nebula
16 - Nebula

Quod Erat Demonstrandum

 

スポイラ
Regex to the rescueRegex to the rescue
Zuza
アステロイド
 
alex
ボリード

Good RegEx practice. 

スポイラ
174 workflow174 workflow174 formulas174 formulas174 results174 results
pasccout
アステロイド

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