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 #164: Retail Therapy

jaredcoffin
7 - Meteor

Good Core Exercise.

joy123
5 - Atom

Answer to the task

svetlana_brazukevich
6 - Meteoroid

Great Challenge!

 

Spoiler
Screenshot 2025-05-22 180831.png
stevev1001
5 - Atom
Spoiler
Great Challenge! spoiler!
StellaBuko
5 - Atom

My Solution. Great Challenge.

#Spoiler 

ScreenshoAlteryx Weekly Challenge.png

AnikaLoots
5 - Atom

Nice challenge and fascinating seeing how others got to the answer!

Here is my attempt.

Weekly Challenge 164_page-0004.jpg

 

subhajit_biswas
7 - Meteor

Solved

Will_Condon
8 - Asteroid

Posted the wrong solution on first reply on May 6, 2025.  Making up for it here.

jwbtx20
8 - Asteroid

As with many of these challenges - they start out so deceptively simple, but then there is usually a catch!  ;)

 

I left my original solution as-is, which means the now-infamous item #1119 got classified as "Outerwear" instead of "Jackets" as in the solution file. 

 

I did an extra little investigation with the published solution workflow (hence the extra Output tool for the original data) to at least see what caused the difference!  It looks like the "Unique" tool in the solution file took the first Field_1 entry, and that picked up the existing class for that record in the subsequent join in the solution.  Sorry for babbling but that was a fun little educational quirk to see regarding the Unique tool!

 

Spoiler
challenge_164_spoiler.png

 

MrMobius
6 - Meteoroid
Spoiler
2025-06-03 144311_challenge_164.png


not sure, if keeping fields in Aggregation via "First" or "Min" etc. is a good idea 😅