86|ALTERYX – Smarty’s School Supplies

BYU Student Author: @Boston
Reviewers: @DylanKing, @TylerBooth, @Christian, @Alex_Garrett
Estimated Time to Solve: 25 Minutes

We provide the solution to this challenge using:

Need a program? Click here.

You are a junior associate at Smarty’s School Supplies that offers bulk supplies ordering. Smarty’s has an audit scheduled next week and the auditor has asked that the databases be in tip top shape when he arrives! This means that all of the databases in Smarty’s system should be in third normal form this link explains what 3NF means!. Your boss has tasked you with a portion of invoices from the month of September and has asked you to find a way to convert the dataset into smaller tables that can easily reference each other. Good luck!

First open the data file and determine what the “key” should be for each table; or in other words, what can uniquely identify each row of data. There should not be any repeat values as primary keys except for the master transaction file which should reference other tables. Make sure to split up the customer’s first and last name into two separate columns as well as the different parts of the address. After you make the four tables, output each one to a separate excel file. Then, upload the four files and output so each excel file is a separate sheet in ONE excel file. Go to this link for help on this complex step.

Data Files

Suggestions and Hints

Try splitting the data into four separate groups: Customer, Product, Invoice, and Invoice Item (the master transaction file). Text-to-column can help split the data. If the second part of the solution brings errors, try using four containers to split the solution into parts to sequentially upload the sheets into one file. The “output option” in the output tool should be “Overwrite sheet or Range”.


techhub2.yxmd (23.3 KB)


This was one of the longer ones that I have done but it was fun! Needed some help from the video.


WeeklyChallengeX_Smartys_School_Supplies.yxzp (25.4 KB)

WeeklyChallengeX_Smartys_School_SuppliesParkerClegg.yxmd (24.2 KB)


WeeklyChallengeX_Smartys_School_Supplies.yxmd (22.0 KB)

1 Like

WeeklyChallengeX_Smartys_School_Supplies.yxmd (23.9 KB)

This was my first time using the unique tool!

This was a fun challenge to try out! I learned a lot from doing this!


TechHub86.yxmd (23.3 KB)

I really like the unique tool, this was also good practice for parsing information


WeeklyChallengeX_Smartys_School_Supplies.yxmd (23.3 KB)

This was a great challenge. I had to use the video for some help

1 Like

Here is my solution to this, it was fun to use RegEx to parse the necessary data for the customer sheet.

1 Like

challenge86solution.yxmd (21.2 KB)
This challenge was a great way to help me learn how to use containers and I actually learned a lot about outputting data to an excel file because I am a very new beginner at Alteryx. Thanks for the challenge!

It took me a long time to figure out how to output the files correctly but this was great practice!

1 Like

Techhub 2.yxmd (25.0 KB)

Challenge 86 Smarty’sSchoolSupplies.yxmd (23.9 KB)
This challenge was good practice on outputting data into Excel spreadsheets, thanks so much!

My Solution!

Homework for Class 11.6.23.
I had some trouble with parsing, so I used a combination of Text-Column and RegEx-- even though it isn’t efficient, it does the work just fine!

1 Like

I used RegEx to create delimiters before doing any text-to-columns. Great challenge!
WeeklyChallengeX_Smartys_School_Supplies.yxzp (23.4 KB)