Alert: There is a planned Community maintenance outage October 16th from approximately 10 - 11 PM PST. During this time the Alteryx Community will be inaccessible. Thank you for your understanding!

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 #445: Help Your Book Club Choose Its Next Book!

Carolyn
11 - Bolide

Solved! I'm glad people are enjoying my challenge! 

 

We went with "The Thing on the Doorstep" for this month, since it's spooky season. 

 

Spoiler
I created a new column to indicate Fiction or Nonfiction. 

I didn't know the RegEx syntax \b until I saw it in @PhilipMannering's solution. That's a handy one to know :) 


2024-10-07_09-19-20.png

alexnajm
17 - Castor
17 - Castor

Better start reading again!

Spoiler
Challenge 445.png
Tofel
8 - Asteroid
Spoiler
Do not know why, but I could not get manual list to work ☹️

Challenge 445 a.jpg

Challenge 445b.jpg



TurboToad
10 - Fireball

My approach for this exercise!

 

Spoiler

 

445.PNG


Filter configuration: [Number of pages] <= [#2] and REGEX_Match([Genres], '.*SEARCH.*') 
#2 comes from the number of pages and the SEARCH value is updated based on the drop down selection.

445d.PNG

Kenda
16 - Nebula
16 - Nebula
Spoiler
image.png
Hub119
10 - Fireball
10 - Fireball

📚Solution attached.

Spoiler
Challenge 445 Pic.png
binuacs
21 - Polaris
Spoiler
image.png

Loved seeing alternative solutions! 

amosteller
7 - Meteor

Spoiler.png

tammybrown_tds
9 - Comet

This sounded more complicated then it actually was.

 

Spoiler
Screenshot 2024-10-07 164038.png