Challenge #164: Retail Therapy

[KaleyVolk1]

Spoiler

[klyuka]

Have a nice day.

[davimariel]

A really good challenge!

Spoiler

[juansagasta]

Spoiler

[dhtay]

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.

[CapriceW]

Here's another!

[LordNeilLord]

8

Spoiler

[JosephSerpis]

Challenge Completed

[Jonathan-Sherman]

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:




Issues with the weekly challenge solution pinned to the thread: