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.

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

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found here."Women Shoe Store" by MyStockPhotos is marked with CC0 1.0"Women Shoe Store" by MyStockPhotos is marked with CC0 1.0

 

For this week's challenge, let’s do a bit of data preparation using shoe inventory data!

 

The following dataset contains a list of shoes with an ID, colors, and sizes available.

 

For this challenge, you want to clean the inventory data and reorganize the list to have:
- A new ID number
- The size
- A comment stating how many colors are available, and
- Three columns for color

 

Keep in mind that the names of the colors are separated by the sign /.

patrick_digan
16 - Nebula
16 - Nebula
Spoiler
patrick_digan_0-1634042196034.png

 

Aaron_Harter
11 - Bolide

Fun challenge!

Spoiler
1.PNG
AngelosPachis
15 - Aurora

Nice quick challenge for this week. Not sure that shoe ID 1533 has 3 colours available though

Spoiler
AngelosPachis_2-1634043166484.png

 

 

Spoiler

Provided output

AngelosPachis_0-1634043110866.png

Input

AngelosPachis_1-1634043131519.png

 

 

PhilipMannering
14 - Magnetar
14 - Magnetar

Solution attached,

 

Spoiler
PhilipMannering_0-1634043233429.png

 

Qiu
17 - Castor

Thanks for the delay. I  finally made it to first 5.

Spoiler
challenge_289.PNG
DeanWest
9 - Comet

This challenge really fits this week! 👟

 

Spoiler
challenge_289_solution_DeanWest-snippet.png

 

AkimasaKajitani
15 - Aurora

My solution.

 

Spoiler
AkimasaKajitani_0-1634045022124.png

 

Blake
12 - Quasar

What's made of leather and sounds like a sneeze? 

 

Spoiler
A shoe!
Spoiler
289.png

What type of shoes do Anurans wear? 

 

Spoiler
Open Toad

 

 

Craig_Renwick
5 - Atom

🤠

Spoiler
Craig_Renwick_0-1634045221644.png