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 #289: Prep a Shoe List

CHarrison
8 - Asteroid
Spoiler
Solution 289.PNG

My solution 🙂 

gsanchez
Alteryx
Alteryx
Spoiler
gsanchez_1-1634239553940.png

 


 

Galilea Sanchez
Program 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
8 - Asteroid

So many colors to choose from!

Miles_Waller
8 - Asteroid

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
7 - Meteor
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
11 - Bolide
Spoiler
allwynthomas24_0-1634309335395.png