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

kelsey_kincaid
12 - Quasar
12 - Quasar
Spoiler

KA-164.PNG

My solution is above. I did have the same problem with Clothing ID 1119 that others are describing.

Alekh
9 - Comet

5 months since the last beginner challenge!

 

Spoiler
164..PNG
kelly_gilbert
13 - Pulsar

I was a bit overconfident on this one! I thought this one would be quick and easy, but ran into some issues (in the first spoiler)...

 

Spoiler
1) Each record in the dataset appears to be an individual review, and some records where the review text has positive sentiment have [Positive Feedback Count] = 0. So, I'm not sure what the [Positive Feedback Count] indicates. Maybe the number of positive feedback instances for the user? In any case, the solution expects the raw [Positive Feedback Count] for each record to be >= 10.

2) The solution includes item #1119 in the Jackets department and Jackets class. My solution includes it in the Outerwear class. Although there are two records that include #1119 in the Jackets class, they would be filtered out due to [Positive Feedback Count] < 10. The instructions didn't indicate using the first class alphabetically, so I'm assuming it's just a small discrepancy in the example data.

challenge_164_1119.PNG
Spoiler
My solution:
challenge_164_workflow.PNG

 

RichoBsJ
11 - Bolide

Hi! Here my solution :)

Wouter
8 - Asteroid

My solution:

Spoiler
challenge 164.jpg
patelki01
5 - Atom

Good Learning Experience!

Verakso
11 - Bolide

Oh boy - this challenge is really splitting people - my self included!

 

I was quick to jump the wagon, that the provided result was "wrong", especially after I could not get it to match and the saw, that my initial solution was pretty much identical to the other provided answers.

 

But two many wrongs does not make it right  - Albeit, English is not my native langues, I began to wonder, do I really understand what is requested?

 

I thought I was, but then I ended up having the issue with Clothing ID 1119 as so many others.

 

So all though I read the task as "find clothes with at least 10 positive feedback reviews AND the five highest rated clothing from these classes", then what it those two requirements is not hard coupled? Then I ended up with my second solution, and it matches the provided output.

 

Spoiler
My solutionsMy solutions

On my way to Lhotse Face

/Verakso

 

 

 

 

 

ponraj
13 - Pulsar

Here is my solution!

 

Spoiler
Retail Therapy.PNG
pasccout
8 - Asteroid

Seemed like an easy one but I guess my English was also not up to par so I ended up with the Jackets issue also.  Thanks @Verakso .

 

Found the Jackets issue quite quickly... the final solution... not so much. :(

Ladarthure
14 - Magnetar
14 - Magnetar

Funny one, pretty straight forward :)