community
cancel
Showing results for 
Search instead for 
Did you mean: 
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Weekly Challenge
Do you have the skills to make it to the top? Subscribe to our weekly challenges. Try your best to solve the problem, share your solution, and see how others tackled the same problem. We share our answer too.
Unable to display your progress at this time. Please try again a little later, or contact an administrator if you continue to see this error.
Announcement | Get certified today - take the Alteryx Designer Core and Advanced exams on-demand now!

Challenge #164: Retail Therapy

Comet
Spoiler

KA-164.PNG

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

Asteroid

5 months since the last beginner challenge!

 

Spoiler
164..PNG
Asteroid

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

 

Asteroid

Hi! Here my solution :)

Alteryx Partner

My solution:

Spoiler
challenge 164.jpg
Alteryx Partner

Good Learning Experience!

Alteryx Partner

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
2019-05-14 14_50_35-Alteryx Designer x64 - challenge_164_solution_verakso.yxmd.pngMy solutions

On my way to Lhotse Face

/Verakso

 

 

 

 

 

Quasar

Here is my solution!

 

Spoiler
Retail Therapy.PNG
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. :(

Bolide

Funny one, pretty straight forward :)