Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!

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 #155: March Cryptanalytics

mtouiti
Alteryx Alumni (Retired)

like that frequency tool, well done

Verakso
11 - Bolide

What a fun and great challenge

 

But my first take I failed miserably 😂

 

Spoiler
kck Who's tnhere? Irisoh! Irish Wcho? Irish kyou a happ y St. PatrKick's Day!no

In the end, my solution ended up looking exact as @nerces so big kudos there 👍

Spoiler

Apparently not many have facilitated the »Data Investigation« tools in Alteryx, but they are some really cleaver tools if you would like to dig deeper in the data itself

The split of the data using RegEx tool and then again using the Summarize tool is not that difficult, I had just not taken into consideration that the order of the letters was determined by the actual frequency, which had me returning that piece of rubbish above.


Of course the correct result is:

knock Knock Who's there? Irish! Irish Who? Irish you a happy St. Patrick's Day!
2019-03-14 10_44_41-Alteryx Designer x64 - challenge155_solution_verakso.yxmd.png

Happy Pi DayHappy Pi Day

 

 

 

 

 

 

 

 

 

 

 

 

 

Still Climbing

/Thomas

SaintVincent
6 - Meteoroid

Let's have beers !!!

sam_seed
5 - Atom

Thanks for a fun challenge!

 

Sam

ggruccio
ACE Emeritus
ACE Emeritus

And the same to you!

 

Spoiler
Hoping to have found a novel solution...I've used summarize "Mode" to determine which character appears most often.  

 

mbarone
16 - Nebula
16 - Nebula
Spoiler
2019-03-14 09_13_12-Alteryx Designer x64 - challenge155.yxmd_.jpg
DataKyle
8 - Asteroid

This was and interesting challenge. Good luck everyone.

 

 

Spoiler

Workflow.PNG

 

adamorse
9 - Comet

Fun! My solution

Spoiler
alteryx weekly challenge 03142019.PNG
catarina_pimpao
8 - Asteroid
Spoiler
AWC_155.PNG
calampert
7 - Meteor
Spoiler
Spoiler!