We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

Challenge #289: Prep a Shoe List

CHarrison
8 - Asteroid
Spoiler
Solution 289.PNG

My solution 🙂 

gsanchez
Alteryx
Alteryx
Spoiler
gsanchez_1-1634239553940.png

 


 

Galilea Sanchez
Technical Customer Success Manager
Alteryx
mike_w
8 - Asteroid

Al Bundy would be proud of us! 

There's a few issues though I'd like to point out: 

- As mentioned by others, there's some duplicate IDs. One entry appears a total five times, and another two times. They have different IDs now which could cause problems! 

- I am not sure why the size "S" was removed in row 192 of the solution?

- row 1533 has already been mentioned by others, this is an interesting case! the original entry is "Lite Grey / Lite Grey / White / Lite Grey". If you ever shopped for shoes and paid attention, then you can conclude that these are most likely two color entries, 'Lite Grey / Lite Grey'   and  'White / Lite Grey'. So it's neither 3 or 4 but 2 colors. This would need manual fixing for now (or a very sophisticated logic - not advised for just one case!). 

Spoiler
mike_w_0-1634241184929.png

 

MJ
8 - Asteroid

Did anybody else remove 1 duplicate and only got 1999 records?

 

Spoiler
MJ_0-1634244285427.png

id = AWpiCHeBJbEilcB6P66J seems to be included in the solution set twice 🙂

BMorgan1390
7 - Meteor

So many colors to choose from!

Miles_Waller
6 - Meteoroid

Not too difficult, but a good challenge nonetheless

 

Spoiler
Miles_Waller_0-1634257899585.png

 

TonyAdam
8 - Asteroid

Why does New ID 192 not have a size in the solution?

 

Spoiler
TonyAdam_0-1634302018788.png

 

Jasmine
5 - Atom

 

Spoiler
289.PNG

Used 'Tile Tool' to make sure the IDs were unique instead of the commonly used 'Record ID' tool.

 

bfitz-gerald
5 - Atom
Spoiler
289.png

Found this one relatively straightforward. Was stuck initially on whether to draw out repeated IDs, but given output didn't seem to do that. 

allwynthomas24
8 - Asteroid
Spoiler
allwynthomas24_0-1634309335395.png