Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
Start Free Trial

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
アステロイド
スポイラ
Solution 289.PNG

My solution 🙂 

gsanchez
Alteryx
Alteryx
スポイラ
gsanchez_1-1634239553940.png

 


 

Galilea Sanchez
Program Manager
Alteryx
mike_w
アステロイド

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!). 

スポイラ
mike_w_0-1634241184929.png

 

MJ
コメット

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

 

スポイラ
MJ_0-1634244285427.png

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

BMorgan1390
アステロイド

So many colors to choose from!

Miles_Waller
アステロイド

Not too difficult, but a good challenge nonetheless

 

スポイラ
Miles_Waller_0-1634257899585.png

 

TonyAdam
アステロイド

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

 

スポイラ
TonyAdam_0-1634302018788.png

 

Jasmine
アトム

 

スポイラ
289.PNG

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

 

bfitz-gerald
メテオール
スポイラ
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
ボリード
スポイラ
allwynthomas24_0-1634309335395.png