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

zoya_asgari
Alteryx
Alteryx

My results are slightly different. I counted for the duplicates and also have one shoe with 4 colors. 

barnap03
7 - Meteor

 

Here's my solution - it seems to be different than most (I removed the duplicates before creating new IDs), but I am sticking to it:

Spoiler
barnap03_1-1634064461217.png

 


 

PatrickW_
Alteryx
Alteryx

first post!

EW
10 - Fireball

Fun challenge!  Pretty sure I could have used fewer tools, but oh well.  

 

Spoiler
My solution differs slightly, I believe because I cleaned the colors and used a unique tool first.  Otherwise I got four (duplicative) colors for one of them.
289_EW.PNG
kceleven11
7 - Meteor
Spoiler
kceleven11_0-1634067765098.png

 

Michael_McKee
Alteryx
Alteryx

Some fun sorting.

 

Spoiler
Capture.PNG

JasonHu
8 - Asteroid

Here is my submission; I got a slightly different output because I was trying to automate the workflow, so I have 4 colours in the output for New ID 1533.

Spoiler
workflow.png
TonyA
Alteryx
Alteryx

The hardest part of this challenge was matching the given solution. I had eliminated duplicate rows and duplicate colors and had to go back and remove all that to get close. But one row in the solution somehow lost the size that was provided in the source data. I drew the line at removing that value just to get an exact match.

Spoiler
TonyA_0-1634083924958.png

 

rmassambane
8 - Asteroid

289!

kelvinlaw
8 - Asteroid

Here is my solution:

Spoiler
kelvinlaw_0-1634089446985.png

kelvinlaw_1-1634089484601.png