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
8 - Asteroid

Hi All,

 

My submission!

-I think that the only difference between my submission and others is that I took the Cypher right from the Wikipedia page and then tokenized it from there...

-Cheers!

 

Matt

 

Highlighted
12 - Quasar
12 - Quasar

I think this is what you are looking for!

Highlighted
8 - Asteroid

I really love working these out on my own and then looking at how others handled the problem to see new approaches.

 

My first take at this was a little clunky but worked by generating a row for each letter in the original message and then applying the rotation, then using the crosstab to put the rows back into a column.

 

After looking at some of the other responses I realized that the regexp -tokenize was a more efficient approach with summary to pull everything back together.

Highlighted
7 - Meteor

 

Spoiler
Solution 163 p1.PNGSolution 163 p2.PNG

 

Here is my solution, used Join+Union (to bring back spaces & punctuation etc) rather than Find & Replace used in other solutions. Preferred to use a Letter mapping rather than Char to Int as you also need to account for the Unicode integer.

 

Thanks!

Highlighted
Alteryx Certified Partner
Spoiler
Challenge163.PNG
Highlighted
11 - Bolide

These cryptography challenges are so much fun! This one reminded me of having a "secret language" with my friends in middle school, so we could write notes in class (it was just a simple substitution cipher).

 

 

Spoiler
First, the macro... It takes inputs of a string, the shift direction (right or left), and the shift value (number of positions, 1-25)...  I should probably simplify that formula:

challenge_163_macro.PNG


The outer workflow for parts 1 and 2:
challenge_163_workflow.PNG


Solution to part 1 (ha ha):
challenge_163_answer.PNG


Solution to part 2 (assuming a right shift):
challenge_163_part2_output.PNG

 

Highlighted
8 - Asteroid

solution attached thanks 

Highlighted
Alteryx Partner

please find my solution attached

Highlighted
8 - Asteroid

Really interesting 🙂 love deciphering codes

 

Need to make this a macro but this is where I got to

Highlighted
Alteryx Certified Partner

Really enjoyed that one. Did Part 1 normally and then converted it into a batch macro to get the correct message from Part 2.

 

Spoiler
challenge_163_macro.PNG
Spoiler
challenge_163.PNG