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

Highlighted
Alteryx
Alteryx

like that frequency tool, well done

Highlighted
Alteryx Certified Partner

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

Highlighted
6 - Meteoroid

Let's have beers !!!

Highlighted
5 - Atom

Thanks for a fun challenge!

 

Sam

Highlighted
12 - Quasar
12 - Quasar

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.  

 

Highlighted
14 - Magnetar
14 - Magnetar
Spoiler
2019-03-14 09_13_12-Alteryx Designer x64 - challenge155.yxmd_.jpg
Highlighted
8 - Asteroid

This was and interesting challenge. Good luck everyone.

 

 

Spoiler

Workflow.PNG

 

Highlighted
9 - Comet

Fun! My solution

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