Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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

mertshepard
8 - Asteroid

Solution attached.

bpiscoya
7 - Meteor
Spoiler
bpiscoya_0-1679852440706.png

 

caltang
17 - Castor
17 - Castor

Done!

 

Spoiler
caltang_0-1680443159606.png

 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
hharris0411
8 - Asteroid
Spoiler
hharris0411_0-1680540601947.png

 

mdm
8 - Asteroid
Spoiler
mdm_0-1680690316986.png

 


 


 


 

Here's my solution and result:

The class name of Clothing ID1119 is "Outerwear" rather than "Jackets". 

mdm_8-1680691269380.png

mdm_9-1680691297666.png

 

Refer to the expected output, the class name of Clothing ID#1119 is "Jackets".

mdm_7-1680691103507.pngmdm_2-1680690816337.png

After checked with the raw data, it shows that the [positive feedback count] of clothing ID 1119 with class name "Jackets" is less than 10.

Hence, clothing ID 1119 of class name "Jacket" should be filtered out in the workflow.

 

Actual raw data:

mdm_10-1680691374117.png

 

 

 

 

 

joeoswald614
6 - Meteoroid

Fun challenge!

 

 

Spoiler

Tools used in order:

  1. Select Tool - change Clothing ID and Positive Feedback Count to Int16. change Rating to Double
  2. Filter Tool - positive Feedback Count >= 10
  3. Summarize Tool - group by clothing ID. Average Rating. First Class Name. First Department Name
  4. Sort Tool - Class Name Ascending. Avg_Rating Descending
  5. Sample Tool - first 5 Rows. Group by Class Name
  6. Select Tool - reorder to Department Name, Class Name, Clothing ID, Avg_Rating
Srikanth_K
5 - Atom

My first challenge completed...

supriyamb83
6 - Meteoroid

Solution for today's Challenge

Sebastian_Chaieb2
9 - Comet
9 - Comet

I have slightly different results as I used Class assigned to ID with highest score and positive feedback. 

There is nothing in objectives what to do with not unique cat for each Cloth ID so in my opinion it is misleading.

 

Spoiler
Sebastian_Chaieb2_0-1680859646563.png

 

NMangera
10 - Fireball
Spoiler
NMangera_0-1680866311683.png

 

TA

-tool container to organise workflow