87|ALTERYX – Password Cracker

BYU Student Author: @Marco
Reviewers: @Alex_Garrett, @Boston, @Mark
Estimated Time to Solve: 20 Minutes

We provide the solution to this challenge using:

  • Alteryx

Need a program? Click here.

There has recently been a data leak from the Brigham Young University School of Accountancy and you’ve been tasked with seeing which students are in danger of having their passwords figured out. You’ve been given a list of student information along with their usernames and hashed passwords to complete your task (you are told that the school hashes passwords with UTF-16). Pull out your laptop and start cracking those passwords on Alteryx!

Build a workflow and get creative to crack as many student passwords as possible using the data provided and your own ideas. (including the top 200 most common passwords). You’ve also been told by the faculty that some students have used passwords related to Brigham Young University and accounting. As part of the challenge, make sure to only use Alteryx, and show your passwords in your solution.

Data Files

Suggestions and Hints

Start off with a blob convert tool. You’ll choose which column to work on/convert. It’s a straightforward tool, but google it if you need help. Another option is the formula tool. A hint in using the formula tool is in the blob convert tool (one of the options).


Challenge 87 Alteryx.yxmd (9.6 KB)

This was a really cool challenge to see!

1 Like

I had no idea what a blob tool was. It was really cool learning what that was and using it to has data.

TechHub Nov1.yxmd (36.8 KB)


I didn’t know about the blob tool for making hashes, but that’s super useful!
TechHubChallenge1.yxmd (15.7 KB)


It was interesting to learn about blob tools!
TechhubAlteryx3.yxmd (8.7 KB)



Challenge_87.yxmd (7.5 KB)
I never knew you could crack a passwords this way Thank you!

1 Like

I thought it was super cool to learn how to crack passwords! I am still a little bit confused on how it works but I thought it was and I am excited for our hackathon in class because I think that this experience will help me.


Challenge87Amy.yxmd (11.7 KB)
Well folks, now I know how to crack some hashed passwords! It was a cool challenge, I liked the use of a blob tool (mostly because it was called a blob tool) and I learned more about joins!

1 Like

Challenge87_KeyyanLugo.yxmd (10.7 KB)
This was a hard challenge for me, but it helped me learn about a new tool.

Challenge 87 Password Cracker.yxmd (13.0 KB)
The blob convert tool is a very interesting and useful tool that I didn’t even think of ever using. Thanks for helping learn how to use it!

I hashed different combination to find matches to the passwords leak, the factors to match those where the following:
A) Most commonly used passwords
B) Most commonly used passwords combine with another most commonly used password
C) First name + last name
D) Last name + First name


Screenshot 2023-11-04 171847

1 Like

This was a really interesting challenge! It was cool combined our AIS knowledge with hashes and such with our Data Analytics skills as well!

1 Like

TechHubChallange87.yxmd (8.6 KB)
Super interesting!

That was fun! I used Chat GPT to generate a list of building names and codes along with other common words associated with BYU after finding the matches with the top 200 most common passwords. I copied the lists generated by Chat GPT and made a separate excel spreadsheet which I input into the workflow. In all, I found 1,269 of the 4,096 records.
PasswordCrackerWF.yxmd (19.2 KB)

1 Like

Here is my solution to the challenge. It was interesting to learn about the blob tool and what it’s capable of.
TechHub3.yxmd (7.3 KB)

Challenge 87.yxmd (7.6 KB)
Cool challenge.

Blob tool is interesting!

Here’s what I have: