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

Tofel
8 - Asteroid
Spoiler
Tofel_0-1665744198607.png

 

jpowellsd
Alteryx
Alteryx

I had to sort the answers to get them to match

Spoiler
jpowellsd_0-1665981975849.png

 

daiphuongngo
9 - Comet

Completed

keynguyen
8 - Asteroid

 

Spoiler

Challenge_337_sol.png

 Spoiler

 

bkurt
8 - Asteroid

My solution is in the attachment.

Thanks for the lesson!

daiphuongngo
9 - Comet
Spoiler
Challenge #337 Create a New List from an Existing List.jpg

JokeFun
8 - Asteroid

The requirement says "contain international movies", but not ONLY international movies. And also the Categories field says (Action and Adventure, Documentaries, etc.), based on which I think we need to keep the full information. So my understanding is there's no need to split the Categories column.

abner-sa
8 - Asteroid

My solution.

 

Spoiler
Just filter the list with:

[type] = "Movie" AND
REGEX_Match([listed_in],'.*International Movies.*')
DataKilroy
8 - Asteroid
Spoiler
DataKilroy_0-1666367432479.png

 

SandeepBabuS
8 - Asteroid

My Solution...!

 

SandeepBabuS_0-1666587544020.png