We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.
We are currently experiencing an issue with Email verification at this time and working towards a solution. Should you encounter this issue, please click on the "Send Verification Button" a second time and the request should go through. If the issue still persists for you, please email support@alteryx.com for assistance.

Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!

Also available in | Français | Português | Español | 日本語
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback

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
7 - Meteor

 

 

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

 

mmotte628
6 - Meteoroid

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

Spoiler
Shoes Challenge.PNG

 

alexnajm
8 - Asteroid

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
14 - Magnetar
14 - Magnetar

My solution in the Python Tool,

Spoiler
PhilipMannering_0-1634050899150.png

 

RolandSchubert
15 - Aurora
15 - Aurora
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
8 - Asteroid

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