Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!

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