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
Hi Community Members,
A solution to last week’s challenge can be found here.
As part of our Weekly Challenge User Group October Takeover event, we selected an exciting challenge submitted by Carolyn Canterman (@Carolyn) from the Seattle User Group. Thank you, Carolyn, for raising the bar with this fantastic challenge!
Your book club is trying to select its next book to read. Each member has submitted a book suggestion which you compiled into an Excel file. Unfortunately, no one can agree on which book to pick next. Luckily, you and Alteryx can save the day!
Your task is to use the provided input file and create an analytics app to help your book club use specific criteria to select their next read. In the app, they should be able to:
- Specify the maximum number of pages.
- Have the option to filter by fiction, nonfiction, or both.
If the list of books that meets the criteria has more than one book, then the app should pick a book at random from that list for the book club to read.
Happy solving!
The Academy Team
c445
@mmontgomery interesting, I see your IN operator captures all case variations (i.e. Nonfiction; nonfiction), I forgot about that in Alteryx, although it's a blessing and a curse.
I suppose the way to ensure an exact match would be with a regex_match and toggling the case insensitivity parameter.
"a" = "A" 🤔
