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

justindavis
ファイアボール
スポイラ
Look at row 1533 
Lite Grey / Lite Grey / White / Lite Grey

Solution has this as "3 colors" but personally I believe it should be cleaned up to be only 2 distinct colors. Thus the longer workflow to filter out duplicates...

challenge_289_solution_jdavis.PNG
Jbone
アステロイド

 

 

スポイラ
Capture.PNG

AlexvanOs
アステロイド

Fun little challenge!

 

スポイラ
The remove 'Size' if the size starts with 'Size' part of this one was a nice addition. 

challenge_289_Solution AlexvanOs.png

 

mikemotter
アステロイド

Nice challenge. I may use this in my upcoming company training. 

スポイラ
Shoes Challenge.PNG

 

alexnajm
18 - Pollux
18 - Pollux

I need some new shoes...

スポイラ
challenge_289_start_file_Alex Abi-Najm.PNG
BHowland
メテオロイド
スポイラ
 

Solution.png

Toons
クエーサー

My solution :

 

スポイラ
Toons_0-1634050285664.png

 

PhilipMannering
16 - Nebula
16 - Nebula

My solution in the Python Tool,

スポイラ
PhilipMannering_0-1634050899150.png

 

RolandSchubert
16 - Nebula
16 - Nebula
スポイラ
289.jpg

My result is a bit different, found a few duplicate records (5) in the inventory data and for some items duplicate colors.

dYoast
ボリード

I tried to use RegExMatch, but got bad results.

スポイラ
Item 192 in the answer does not have a size.  I left mine.
dYoast_0-1634052876661.png