Data Prep is Murder, literally in some cases - CHALLENGE

[chris_love]

I wanted to let everyone know that tomorrow the UK Midlands Alteryx User Group are hosting their first meeting......and there's going to be something going down in Leicester town - a murder! 

Now should you want to help us solve this ghastly crime then come back to this post tomorrow around 6.30pm BST (1.30pm EDT) and we'll be working on some data clues (which we'll also post here) and help the detectives in Leicester piece together the puzzle behind this terrible crime and catch the murderer before he slips away. Good job we've got just the tool!

[cbridges]

Wow! I wish I understood RegEx better, because that workflow is beautiful!

[chris_love]

Great work guys - love some of these solutions!

Now we have the username but we need to know who it relates too. The username has been scrambled by a caeser cipher (shifting the letters along A=B, B=C, etc) - can you shift the letters along one way or another using Alteryx and crack the case? Let us know who the murderer is - he's on the forum somewhere.....

[cbridges]

I suspect (see what I did there?) there's an easier way. Looking forward to seeing the other solutions.

What great fun and such a learning experience for me.

Let's play more Alteryx games like this!!

[TaraM]

want me to ban the account, @chris_love? I got your back ;)

Spoiler

[TaraM]

@cbridges beat me to the punch! It was the cropping the sensitive info in photoshop that took the extra time!

[cbridges]

I'm sure you'll beat me by a kilometer in the Fun Run, so we'll call it even! LOL!

[jdunkerley79]

Well done @cbridges and @TaraM

Attached my go

[TaraM]

Love it @jdunkerley79, I was fiddling with the mod function and couldn't get it. 

[jdunkerley79]

Was trying to think of way to do it tighter with some weird regex but couldn't think of a way. Mod seemed nice as could then introduce a constant to cope with different shifts.

If @chris_love had murdered himself we might have needed to crack Enigma!

Thanks to @MikeMoss and Chris for setting these. What a great start for the user group.

[cbridges]

OMG Tara, that's so simple! Thank you for introducing me to yet another tool that I've never used, but will use OFTEN from now on!