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

Highlighted
8 - Asteroid

m sure this is correct, but the expected translates you to youyay (as if it begins with a vowel). But heres my go, it deals with the punctuation, casing and spaces (so many trailing spaces ) would like to come back to this and make it more reasuable.

Spoiler
 

 

 

 

 

Highlighted
Alteryx Certified Partner

Quite a bit of tweaking involved in this problem!

 

Spoiler
challenge_174.PNG

 

Highlighted
8 - Asteroid
Spoiler
clipboard_image_0.png
Close enough. Spent enough time on this. Didn't capitalize sentences and I have some incorrect quotes. Learned about the ::punct:: regex though.
Highlighted
Alteryx
Alteryx

There has to be a cleaner solution than this. But I did want to make sure that any group of consonants however long, would be properly translated (thinking of words like "chrysalis").

Highlighted
7 - Meteor

Had to do it two times because I didn't like how I did it the first time.

Spoiler
clipboard_image_0.png
Highlighted
Alteryx Partner

Surprisingly complicated with all the different possibilities....

Highlighted
16 - Nebula
16 - Nebula

This is a great example of

a) a challenge that is directly tied to some of the interactive training that's available  https://community.alteryx.com/t5/Interactive-Lessons/Using-RegEx-in-Expressions/ta-p/424427

b) a workflow that is different during development than the final product

 

Good fun - thank you!

 

Spoiler

Build this using a flow that broke this into one word at a time to make it easier to debug:
Trick is to use Regex that uses named elements ($1) to do this fairly simply

Split Flow by Word.pngTestingInProgress.png


The final flow then removes the TextToColumns tools to keep the sentances whole.

FinalFlow.png

Highlighted
7 - Meteor

There are a number of different solutions here, I have used regex in mine, but I'm not sure how well it would work if there were numbers as well as letters.

 

Spoiler
Capture.PNG
Highlighted
Alteryx Certified Partner
Alteryx Certified Partner

Challenge 174 completed in just 6 tools! Got to love RegEx!

 

Spoiler
challenge 174 JMS solution.PNG
Highlighted
8 - Asteroid

There are two important things we should concern in this case:

1) The Message will be truncated due to its format (V_String-89), so we should modify the format first.

2) About the Pig_Latin rules, I used "A/E/I/O/U" as the key to find out transfer rules. But there's an exception when I compare the result. That is "you", we should transfer it to "youyay" other than "ouyay". So I added "you" into vowel list.

Spoiler
Annotation 2019-12-25 135013.pngAnnotation 2019-12-25 140342.png