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!
SOLVED

## Challenge #163: Caesar Cipher (on the way to Kryptos)

Alteryx

ROT-13 came into moderate use during the height of Usenet as a way to obscure profanity, dirty talk, movie spoilers, and offensive materials from the casual glance.

The Challenge here is to implement the ROT-13 substitution cipher and apply it TWICE to verify that the ENCODER can be used as its own DECODER!

If you are up for a challenge skip to PART II (which also solves PART I)

Asteroid

Those book fair Spy books finally pay off

Spoiler
You could use a switch formula in place of the lookup, but this works too

Part 1 just changes the filter to specify shiftkey 13
Comet

Created it as an app so your kids can learn Alteryx while sending secret messages to their friends!

Spoiler

Asteroid

Hi! Here my solution!

Spoiler
Part I:

Part II:

Macro detail:

Magnetar

LOVED THIS CHALLENGE. (To be fair, I just did my first Escape Room this weekend, so I'm kinda still psyched about the whole solving puzzles thing...)

Spoiler
Decided to solve both parts, and then took a cue from @T_Willins and made an app out of it so that you can code/decode your own messages!

Part I:
Solved without having to hard code a key by utilizing my favorite lesser-known formula, CharToInt and CharFromInt. Able to create a 3 tool solution (Parse > Formula > Summarize) that will allow you to code/decode ROT-13 messages, including the ability to keep upper & lowercase letters in their original case.

Part II:
For Caesar's Cipher, I used Generate Rows to create 26 possible rotations, and then more-or-less used the same solution as above, just substituting the RowCount field from Generate Rows tool for the 13 used in Part I. Solution = some advice that certain members of the kingdom of Westeros would be wise to heed... attack at once!! ;)

Part III:
Created an app out of the solution above... and then had to entirely rework it once I realized that the same value could not be used to decode the message as to encode it if that number wasn't 13. Oops. So I modified both to allow for encoding as well as decoding, which now gives you a handy little Cipher for sending secret messages behind enemy lines!

Cheers!

NJ

Alteryx Partner

Doing it on Alteryx 11.7 :(. I've been doing a lot of iteratives recently so decided to do it with an iterative.

Spoiler

Aurora

I'm on the same wavelength as @NicoleJohnson

Spoiler
Alteryx Certified Partner

My solution, using the same approach as @NicoleJohnson and @patrick_digan

Spoiler
Highlighted
Aurora

My solution for both in one WF

Spoiler
I used the "generate all shift" keys method.

Since the decoder ring is circular, you can either shift the letters up or shift them down.   @patrick_digan
shifted Caesar's message 22 letters up, I shifted mine 4 letters down

Dan

Quasar

These cryptic challenges are good fun! :)

Spoiler
I went down the macro route

Can't leave a challenge behind, so of course started with Part II

Luckily it worked on part 1 too :)