Challenge #445: Help Your Book Club Choose Its Next Book!

[AYXAcademy]

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

[BS_THE_ANALYST]

Best sign up to a book club! 😎

Spoiler

 

[mmontgomery]

c445

Spoiler

Pivoted the genres column to rows to make it easier to select values. Updated solution to have a random sample pick one value at end

[BS_THE_ANALYST]

@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" 🤔

[mmontgomery]

@BS_THE_ANALYST If case matters, then yes, regex match or contains (using the third optional parameter for case insensitivity are options). Yeah, IN will grab case variations, but you can always standardize the case syntax before doing any operations so Nonfiction becomes NONFICTION or nonfiction, etc.

[RolandSchubert]

Spoiler

[AkimasaKajitani]

My solution!

Spoiler

[PhilipMannering]

Solution attached.

Spoiler

[Powerhouse_21]

Spoiler

 

 

[MitchyMitch]

Had fun with this one! ^.^

Spoiler