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

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 #337: Create a New List from an Existing List

leonhekkert
8 - Asteroid

My solution:

 

 

Spoiler
Challenge_337.png

Seems a bit strange to my that the solution sorts duration as text without using the dictonary order instead of sorting as a number, but OK.

 

 

Ed2000
8 - Asteroid
Spoiler
Ed2000_0-1675255262161.png

 

elaineyuan
8 - Asteroid

In the Categories column, I removed "International Movies" and kept the other categories.

Spoiler
challenge_337_elaine_yuan.png
RobertOdera
13 - Pulsar

My solution is below. Cheers.

Spoiler
Challenge_337.PNG
caltang
17 - Castor
17 - Castor

Done! Fun stuff:

 

Spoiler
caltang_0-1675432189281.png

 

Calvin Tang
Alteryx ACE
https://www.linkedin.com/in/calvintangkw/
estherb47
15 - Aurora
15 - Aurora

A different sort order (I parsed out the minutes) in the end result

 

 

gaoa
11 - Bolide
Spoiler
gaoa_0-1675620263042.png

 

vnicoletgregoire
8 - Asteroid
Spoiler
vnicoletgregoire_0-1675708227146.png

 

CeliaC_Silje
8 - Asteroid
Spoiler
hycheungal_0-1676014045749.png
patrickprentice
8 - Asteroid

Solution: