alteryx Community

# Weekly Challenges

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
###### IDEAS WANTED

Want to get involved? We're always looking for ideas and content for Weekly Challenges.

SUBMIT YOUR IDEA
SOLVED

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

Alteryx Alumni (Retired)

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)

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

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

Spoiler

11 - Bolide

Hi! Here my solution!

Spoiler
Part I:

Part II:

Macro detail:

ACE Emeritus

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

9 - Comet

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

Spoiler

17 - Castor

I'm on the same wavelength as @NicoleJohnson

Spoiler
16 - Nebula

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

Spoiler
19 - Altair

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

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 :)