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
13 - Pulsar

I also learned the STRCSPN function in this challenge.  I really enjoyed this one as it forces you to look at data in an atypical way.

 

Nubext wubill wube trubanslubate ubintubo ububbubi dububbubi? (but only if you watched Zoom on PBS!)

 

Spoiler
Workflow 174.GIF

 

 

Highlighted
12 - Quasar
12 - Quasar

EryVay appyhay ithway ethay esultsray!

Highlighted
14 - Magnetar
14 - Magnetar

Egexray orfay ethay inway!

 

Spoiler
WeeklyChallenge174.JPG

Eerschay! 🙂

NJ

Highlighted
Alteryx Certified Partner

icksay oneyay

 

Spoiler
Snag_19d9dda5.png
Highlighted
8 - Asteroid

All fairly straightforward - but got caught out by the "Title Case" within my REGEX_Match function. Who would have thought that even though using \u to detect upper case letters that you would still need to specify case sensitivity!?!

 

Spoiler
clipboard_image_0.png
Highlighted
17 - Castor
17 - Castor

Hi @EstherB47 

 

Well, you know the second half of the "Great Minds" expression.

 

Dan

Highlighted
8 - Asteroid
Spoiler
Week174.PNG

I was not able to attach my completed workbook, so hopefully a picture works for credit.

Highlighted
8 - Asteroid

My solution is dirty one - using string formulas and iif cases to create words for replacement.

But I don't need to use RecordID Tool and to deal with punctuation keeping.

Only thing I haven't done - parsing Upper-case. 

***

I thought this challenge could has a beautiful solution with LR(1) parcer. 

Such parcer will be written as a number of rules for itterative substitutions vis Alterix FindReplace Tool.

 

Stage 1  - move start consonant to end of the word

" " + Stage0 + consonamt -> " " + consonant + Stage1

consonant + stage1 + letter -> letter + consonant + stage1

consonant + stage1 + " " -> stage2 + consonant  + " "

 

Stage 2 - back to the beginning

letter1 + stage2 + letter2 -> stage2 + letter1 + letter2

" " + stage2 + letter = " " + stage3 + letter

...

Highlighted
Alteryx Partner
Spoiler
clipboard_image_0.png

I tried to organize the workflow breaking it by criteria:

 

Criteria 1 - Begin with one consonant

Criteria 2 - Begin with consonant cluster

Criteria 3 - Begin with vowel

 

* The remaining cells after applying all criterias are all empty values.

 

Hope the comments in the workflow can help to easy understand it.

 

Really nice challenge. Thank you!

Highlighted
17 - Castor
17 - Castor

Hi @bkclaw113 

 

Unfortunately, The workflow is required to get the credit.  What problem did you have attaching the workflow?

 

Dan