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

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

AYXAcademy
Alteryx
Alteryx

A solution to last week’s challenge can be found here.

 

How often do you have to create a new list based on another one?

This is what we are doing in this challenge.image337.PNG

 

The following dataset contains information about shows on Netflix. Use the dataset to create a new list with the following information:

 

- Categories (Action and Adventure, Documentaries, etc.)
- Type
- Title
- Release Year
- Rating
- Duration

 

This list should only contain international movies arranged in order by the year of release and duration.

Luke_C
17 - Castor
17 - Castor
Spoiler
Luke_C_0-1663596718257.png

 

Kenda
16 - Nebula
16 - Nebula
Spoiler
If you sort by actual minutes of each movie, you get a slightly different sort order than answer given:
Kenda_0-1663596596374.png

 

But if you sort by the original duration field and don't use dictionary order, order matches output:Kenda_1-1663596776058.png

 

ahsanaali
11 - Bolide
Spoiler
Spoiler
ahsanaali_1-1663597133536.png

 

patrick_digan
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1663597404445.png

 

AkimasaKajitani
17 - Castor
17 - Castor

My solution.

 

Spoiler
The order of output is little strange. About duration, it is sorted as string. 
AkimasaKajitani_0-1663597924422.png

 

AProblemSolver
5 - Atom

AProblemSolver_0-1663598070672.png

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
327.png
ggruccio
ACE Emeritus
ACE Emeritus

Many ways to do this one.

Spoiler
I chose to Parse and find International Movies / Tokenize.  I also split out the numeric component of the duration and sorted on that.  The answer key is sorting the duration on alphabetical order which is why I get an error on 'Expect Equal'
ggruccio_0-1663599257426.png

 

MilindG
12 - Quasar
Spoiler
MilindG_0-1663600045892.png