Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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 #472: School Supplies Cost How Much?! Part 1

RWvanLeeuwen
11 - Bolide

here's my take

(could have been in less tools, but it's fine, because it is only tiny data with ~30 + ~30 rows)

 

Spoiler
472.png
Carlyn
8 - Asteroid

Definitely need to work on my Regex knowledge as not as smooth as the other solutions!

Jonathon-Sheppard
8 - Asteroid

:)

niklas_greilinger
11 - Bolide

My Solution

Spoiler
472.png
Milanz
9 - Comet

my solution ;-)

 

Spoiler
472.jpg

alexgibson
7 - Meteor
Spoiler
Screenshot 2025-04-15 082228.png
tkemp
7 - Meteor

If you think the price of school supplies is bad for the student, try being the teacher --\_(=])_/--

jeprime
8 - Asteroid

I was for 10 years, which is why I am now a data analyst.

jeprime
8 - Asteroid

In my solution, I used the data cleansing tool and changed the punctuation on all items in both data sets, which improved the join 100%. Just an FYI.

tkemp
7 - Meteor

Two years of teaching high school mathematics for me. 

 

Feels like this would be cleaner if I'd put the Data Cleansing tool up front like you said. Good suggestion!