community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #174: Appyhay Ondaymay!

Comet

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

 

 

Bolide
Bolide

EryVay appyhay ithway ethay esultsray!

Egexray orfay ethay inway!

 

Spoiler
WeeklyChallenge174.JPG

Eerschay!

NJ

Asteroid

icksay oneyay

 

Spoiler
Snag_19d9dda5.png
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
Aurora

Hi @EstherB47 

 

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

 

Dan

Asteroid
Spoiler
Week174.PNG

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

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

...

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!

Aurora

Hi @bkclaw113 

 

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

 

Dan