Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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
10 - Fireball
Spoiler
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
8 - Asteroid

 

 

Spoiler
Capture.PNG

AlexvanOs
8 - Asteroid

Fun little challenge!

 

Spoiler
The remove 'Size' if the size starts with 'Size' part of this one was a nice addition. 

challenge_289_Solution AlexvanOs.png

 

mikemotter
8 - Asteroid

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

Spoiler
Shoes Challenge.PNG

 

alexnajm
17 - Castor
17 - Castor

I need some new shoes...

Spoiler
challenge_289_start_file_Alex Abi-Najm.PNG
BHowland
6 - Meteoroid
Spoiler
 

Solution.png

Toons
12 - Quasar

My solution :

 

Spoiler
Toons_0-1634050285664.png

 

PhilipMannering
16 - Nebula
16 - Nebula

My solution in the Python Tool,

Spoiler
PhilipMannering_0-1634050899150.png

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
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
11 - Bolide

I tried to use RegExMatch, but got bad results.

Spoiler
Item 192 in the answer does not have a size.  I left mine.
dYoast_0-1634052876661.png