Pardon our dust - Alteryx Academy is under construction. Lessons and courses completed on Community from now until January 20th will not be recorded.
Start 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

olga_zunii
Atome

Spoiler!

APIUserOpsGiri
Météore

gvenkatapathy_0-1663770628449.png

 

Mannyw892
Atome

My solution to Challenge #337

Jay_French
Atome

I feel the provided output is actually incorrect. It removes all categories except "International Movies" (the instructions don't say to remove the other categories from the movie, only to filter to only International Movies), and it doesn't sort by duration after sorting by release date. My answer gives the output the challenge actually asks for. :)

Mannyw892
Atome

Below is the instructions for the challenge #337, please see the text in bold

 

Weekly Challenge #337

 

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

This is what we are doing in this challenge.

 

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.

karlhansen
Comète
Révélation
solution_337.jpg

I added a text entry for easier selection of film types "in the real world".

The solution provided in the start files does not sort by duration.

Mannyw892
Atome

Weekly Challenge #337.

KarenYL
Astéroïde
Révélation
Screenshot 2022-09-21 105842.png

tammybrown_tds
Comète

Another very simple one.

 

Révélation
tammybrown_tds_0-1663789521582.png

 

Marie_K
Météoroïde

(spoiler alert)  Here is my solution.