Data Prep is Murder, literally in some cases - CHALLENGE

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!

Preparation

Events

Accepted answers

cbridges

Fun!

Here's an alternative solution to part 1, for those with limited knowledge of certain methods...could have done it with one less tool if I were more familiar with said methods.

(I'm being vague to avoid spoilers.)

Murder Mystery 1 cb.yxzp

Nitish_Salve

@cbridges I tried to customize your workflow, just have a look.

Murder Mystery_1_N.yxzp

cbridges

I love what I'm learning along the way... I used the limited knowlege I had to come up with an alternative solution, and now I also know how to do it your way! :-)

Murder Mystery 2 cb.yxzp

jdunkerley79

Nice challenge @chris_love.

Attached a quick go at pt 1 & 2

Murder Mystery 1 JD.yxzp

TaraM

So fun! I was pretty stoked I got the regex in step one in one tool Love me some regular expressions!

Murder Mystery 1-tm.yxzp

Murder Mystery 2.yxzp

All comments

chris_love

Here we go... being murdered wasn't fun (neither was the wifi).

The Case - Part 1 of "Who killed @ChrisLuv": Get some usable data.

Once Part 1 is solved by the community detectives I'll post Part 2.

Murder Mystery 1.yxzp

chris_love

By the way HUGE thanks to @MikeMoss for putting this together, really good fun that I can't take any credit for.

cbridges

Fun!

Here's an alternative solution to part 1, for those with limited knowledge of certain methods...could have done it with one less tool if I were more familiar with said methods.

(I'm being vague to avoid spoilers.)

Murder Mystery 1 cb.yxzp

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.....

Murder Mystery 3.yxzp

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!!

Murder Mystery 3 cb.yxzp

TaraM

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

Spoiler

2016-05-26 12_47_54-Users - Alteryx Community.png

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.

JohnJPS

I used a formula tool with various String functions, attached.

Edit: updated with the rest of Part 2 pieces.

Murder Mystery 1 - jps.yxmd

cbridges

Your solution has me thinking "what the what?"

I'm teasing it apart to figure out exactly what you did!

TaraM

Wow @JohnJPS - a minimalist! slick.

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15867

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703