# 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.
SOLVED

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

Highlighted
Alteryx Community Team

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)

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

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

Spoiler

Highlighted
8 - Asteroid

Hi! Here my solution!

Spoiler
Part I:

Part II:

Macro detail:

Highlighted
14 - 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

Highlighted
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

Highlighted
16 - Nebula

I'm on the same wavelength as @NicoleJohnson

Spoiler
Highlighted
Alteryx Certified Partner

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

Spoiler
Highlighted
17 - Castor

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

Highlighted
12 - 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 🙂