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

Meteor
Spoiler
Untitled.png
Asteroid

Have a nice day.

Meteoroid

A really good challenge!

 

Spoiler
Solution_164.PNG
Alteryx Partner
Spoiler
Spoiler.PNG
Meteor

Done. I only found out about the option to group by fields in the sample tool after finishing the challenge, so I used the multi-row formula tool instead.

Atom
 
Asteroid

Here's another!

Alteryx Certified Partner

8

Spoiler
Capture.PNG
Asteroid

Challenge Completed

Challenge 164 is completed! However does not match the proposed output. I've outlined why i believe there is (and many others) have found a difference when creating their workflow:

 

Spoiler
So i believe I've found why most people have been getting a difference between their output and the expected output. The solution takes a unique of the list on  rather than clothing id, department id and class id. Since we have a jacket class and outwear class version for clothing id 1119 the unique tool will lose the outwear class version. When joining this back onto our initial flow it will change the only row with a positive feedback count for item 1119 greater than or equal to 10 from an outwear class to a jacket class and thus placing it in the wrong group when we come to summarise and sort the output.

My solution:

challenge 164 JMS solution.PNG


Issues with the weekly challenge solution pinned to the thread:

Challenge 164 solution disagreement (1).PNGChallenge 164 solution disagreement (2).PNGChallenge 164 solution disagreement (3).PNG