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

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
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1634042196034.png

 

Aaron_Harter
11 - Bolide

Fun challenge!

Spoiler
1.PNG
AngelosPachis
16 - Nebula

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
16 - Nebula
16 - Nebula

Solution attached,

 

Spoiler
PhilipMannering_0-1634043233429.png

 

Qiu
20 - Arcturus
20 - Arcturus

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
17 - Castor
17 - Castor

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