cancel
Showing results 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!

Alteryx Partner
Solution.
Asteroid

Iyay ontday understandyay ouryay econdsay ordway

Bolide

Took a bit of trial and error on different words and phrases to get the correct translation. Fun challenge!

Spoiler
Meteoroid

First challenge, it was a fun challenge. There is definitely a lot of optimizing I could do with the logic, but it's a good start.

Moderator

Alteryx Certified Partner

Challenge Completed

Alteryx

A tough challenge!

The hard part was thinking around how to examine the two letters of each word and action on them.

Rewarding to complete.

Spoiler
Alteryx Certified Partner

Brute force, but I got there.

Spoiler
I began by creating a Record ID, I then used the Text to Columns tool to split the words to rows on every space (a row per word). I then isolated the non-blank rows. I then split the stream to isolate those records that contained quotes, and I then used the formula tool to create two columns representing the leading and trailing punctuation marks. I then cleansed the words so they contained no punctuation marks, I then unioned them back together:

I then created two streams handling those words that begin with a vowel, built in the logic to create the pig-latin word on each steam then unioned back together. I then isolated the first record of each sentence and made these words title case, with the others being set to lowercase. Once I had everything in the format I required I created a title column then cross-tabbed the records grouped by Record ID, with "Title" as the title column ("Message"), with the message being the column data and the cross tab set to concatenate with a \s as the divider:

Alteryx

Not the best looking workflow of all time! I have annotated to try make it look a bit nicer.

Bringing back in the punctuation was a big challenge. I broke this down in a few formula tools so I could track progress as I went along.

Happy to have completed it, I can now speak Pig Latin...

Spoiler
Aurora
Spoiler
I decided to use Regex and it didn't turn out as pretty as I was hoping for. Every time I use regex, I realize how little I actually know regex.