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.
We'll be completing standard maintenance for our Single Sign-On system on November 30th 6pm Pacific Time for approximately one hour. During this time My Alteryx and sign-in functionality to all My Alteryx programs (Licensing Portal, Community, Beta Program, Case Portal, and others) may be inaccessible. Thank you for your patience.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #322: Good Ladies Heist

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found here.

 

Welcome to the Good Ladies weekly challenge!

 

Five women heist a jewelry store and steal a precious gem in the shape of a ball of yarn.

 

In the dataset, the 5 women responsible for the heist have been negligent and left clues behind.
You are the detective on the case who is looking for these clues in a dataset. image_322.png

 

1. Fingerprints on the glass surrounding the gem show fingerprints belonging to someone with the letters "Fled" in their first name or last name.

 

2. IT Department at the police is able to find that the back door lock password was changed to "ugfsjsh".

 

3. The vault holding the gem was blown open with "dynamic" dynamite. Found in the ruble is a business card piece. You can make out the first few letters of the word "Bogi"

 

4. The security guard's witness statement states that he has been vigilant about watching the store. There was only one instance last week when he was distracted by a woman with brunette hair who worked at a wireless store. He remembered later that she'd dropped a handkerchief that had the initials B.K. on it.

 

5. A slogan was left behind that said, "Those that synergize together can accomplish much and receive the TORPHY."


First, you will have to parse the data.

CHarrison
8 - Asteroid

My solution :)

Aaron_Harter
11 - Bolide

Love the Filter for Detective work!

Spoiler
0.jpg
IraWatt
17 - Castor

Looking forward to seeing others approaches.

Spoiler
IraWatt_0-1654524167069.png

 

mmontgomery
8 - Asteroid
Spoiler
mmontgomery_0-1654524310053.png

 

AkimasaKajitani
16 - Nebula
16 - Nebula

My solution.

 

Spoiler
AkimasaKajitani_1-1654524535002.png

 


 

alexnajm
10 - Fireball

Filters for days!

Spoiler
Challenge 322.PNG
danagabiti
5 - Atom

A nice one to start the week off.

Spoiler
DFAJ_SOLUTION.PNG
PhilipMannering
15 - Aurora
15 - Aurora

Solution attached,

 

Spoiler
PhilipMannering_0-1654527493486.png

 

Bonnn
5 - Atom

:)