Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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

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
17 - Castor

Looking forward to seeing others approaches.

Spoiler
IraWatt_0-1654524167069.png

 

mmontgomery
11 - Bolide
11 - Bolide
Spoiler
mmontgomery_0-1654524310053.png

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
AkimasaKajitani_1-1654524535002.png

 


 

alexnajm
17 - Castor
17 - Castor

Filters for days!

Spoiler
Challenge 322.PNG
danagabiti
5 - Atom

A nice one to start the week off.

Spoiler
DFAJ_SOLUTION.PNG
PhilipMannering
16 - Nebula
16 - Nebula

Solution attached,

 

Spoiler
PhilipMannering_0-1654527493486.png

 

Bonnn
5 - Atom

:)