86|ALTERYX – Smarty’s School Supplies

[Sierra_Smith]

I used RegEx to separate the customer name and address. A great challenge!

[Camilla_Farnsworth]

Great challenge! Took me some time, but I got it!

[Juliette_Sorensen]

[Jaxon_Floyd]

This was a great one! I got stuck cleaning the data on one spot but the video helped–it ended up being a lot simpler than I expected.

[Max_Keyser]

Smarty problem.yxmd (23.0 KB)

[Dane_Collins]

This one was a little confusing for me, still good though.

techhub6.yxmd (22.6 KB)

[Mckay_Abbott]

Here is my solution!

Challenge86_Mckay_Abbott_Solution.yxzp (22.7 KB)

[luisg99]

This problem can be solved easily when you pause I think about how many results you need and how they are supposed to look. I have four different tables here they are:

One of the screenshots includes one of the tables as well as the workflow!

[Katie_Morgan]

Here’s my solution!

[Young_Lee]

WeeklyChallengeX_Smartys_School_Supplies.yxzp (23.5 KB)

[Caleb_McKay]

I loved the refreshing on 3NF and how Alteryx can help us sort data in that way.

[Lucas_Argente]

Time to complete: 30 minutes
Difficulty: Beginner
Solution:

[Clayton_Roberts]

Time: About 20-30 min
Difficulty: Beginner
I was lost in the beginning so I looked at the hints/solution to check. After I got the help everything made more sense and it really isn’t that complex.

[Tyson_Burrup]

Time to Complete: 30 minutes
Level Beginner
Good practice problem

[Aaron_Christensen]

Time: 25 minutes.
Difficulty: beginner in terms of Alteryx. More effort was needed to review third normal form to understand the objective. Note: in my solution i used observe funcitons instead of exporting a csv for convenience and to keep my folders uncluttered.

[Alycia_Larimer]

Time to complete: 25 mins
Rating: Beginner

[Emma_Brown]

Time to complete: 20 minutes
Fun to learn how to use the data cleaning tool to remove whitespaces! I hadn’t used it before.
Smarty’s School Supplies.yxmd (17.0 KB)

[Madeline_Larkins]

Time to Complete: 25 min
Level: Beginner

[Avalon_Porter]

Time: 30 min
Challenge: Beginner
Good challenge, taught me new tools.