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

CSmith16
9 - Comet

Answer:

 

Spoiler
Screenshot 2025-04-15 105419.png
Screenshot 2025-04-15 105507.pngScreenshot 2025-04-15 105544.png
DylanBell
10 - Fireball

A day late, but better late than never!


Bulien
olga_strubbe
11 - Bolide

Thank you, Talia @tsand22

This was a nice sample of a real-life challenge.  I've added a supplementary sort input to sort the grades of the Elementary school from youngest to oldest. 

Spoiler
2025-04-15_11-14-19.png
Result:
result.png
Will_Condon
8 - Asteroid

Nice opportunity to try Regular Expression to parse the Supply List.

Spoiler
 
Challenge 472 School Supplies Cost How Much Part 1 Spoiler.jpg

 

 

LorraineF
7 - Meteor

My solution

jeprime
8 - Asteroid

In retrospect, I see that I have what looks like could be solved using a macro, had I just thought about it longer.

ganu97
5 - Atom

Hello mate, I tried doing this similar to you, however after then join Tool i was only able to get 52 items as opposed to the 102 you got. Can you please tell me what am i doing wrong here

TurboToad
11 - Bolide

Nice, fun challenge!

Spoiler
image.png
Jennhoo
8 - Asteroid

My solution.  Fun one!

DaisukeTsuchiya
14 - Magnetar
14 - Magnetar
Spoiler
スクリーンショット 2025-04-16 085345.png