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.
2022.1.1.30569 Patch Release Update

The 2022.1.1.30569 Patch/Minor release has been removed from the Download Portal due to a missing signature in some of the included files. This causes the files to not be recognized as valid files provided by Alteryx and might trigger warning messages by some 3rd party programs. If you installed the 2022.1.1.30569 release, we recommend that you reinstall the patch.

Weekly Challenge

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

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

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

Submit Feedback

Challenge #259: Disenvowel

AYXAcademy
Alteryx
Alteryx

A solution to last week's challenge can be found herewooden-cubes-2x1.jpg

 

This week's challenge was submitted by @MarqueeCrew  based on this post - Thanks for your submission! Be sure to check out the accompanying blog post!

 

In this challenge we need to create a workflow to remove vowels from text, excluding vowels that are the first letter in a word. Y is included as a vowel for this challenge...

Aaron_Harter
11 - Bolide

Arn cmpltd!

Spoiler
1.PNG
Maskell_Rascal
13 - Pulsar

Fun little RegEx challenge to start the week! Here is my solution. 

 

Spoiler
REGEX_Replace([Input Data], "\B[aeiouyAEIOUY]", "")
MarqueeCrew
19 - Altair
19 - Altair

Here's my blog post about the original post:

 

https://community.alteryx.com/t5/Engine-Works/Accepted-Solution-Deep-Dive-to-RegEx-or-Not-to-RegEx/b...  

 

I do encourage everyone to explore that blog and the original post.  Please do comment along the way.  

cheers,

 

 mark

Alteryx ACE & Top Community Contributor

Chaos reigns within. Repent, reflect and restart. Order shall return.
Please Subscribe to my youTube channel.
Luke_C
16 - Nebula

Tried with the usual formula approach I would use, and also learned something new with the regex method mentioned in original thread

 

Spoiler
Luke_C_1-1615814691180.png

 

Blake
12 - Quasar

All st on ths chllng

 

Spoiler
259.png

 

 Chck ot m vd sltn blw

(Check out my video solution below)

Spoiler
jferrone
8 - Asteroid
Spoiler

Chllng Cmpltd

jferrone_0-1615815182191.png

This is a different approach as I haven't really used Tokenize. Results matched. Reattached solution workbook with both options. 

jferrone_0-1615816398243.png

 

DeanWest
9 - Comet

Fun one-tool challenge! :formula:

 

Spoiler
challenge_259_Solution_DeanWest-snippet.png

 

patrick_digan
17 - Castor
17 - Castor
Spoiler

patrick_digan_1-1615817188713.png

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
259.jpg