Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.

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 #230: Take a Look, It's in a Book!

pirroav
6 - Meteoroid

First pass at a solution, where the best seller year is based on the date of publication. 

 

edit: uploaded the wrong version, oops!

Tony_Castillo
9 - Comet
Spoiler
TC_bot_0-1598286021848.png TC_bot_1-1598286032569.png

 

2014 result is tied at 9 - 'The Best of Me' by Nicholas Sparks  (Matches answer in output) & 'The Target' by David Baldacci (New Answer). Based on sorting rule, David Baldacci's 'The Target' wins as he had the higher # of weeks result. 

huynv96
9 - Comet

try to comment

RobertW
Alteryx
Alteryx

Not too bad.  Needed the brush-up on reporting tools.

 

Spoiler
RobertW_0-1598289690805.png



RobertW_1-1598289753917.png

 

TonyA
Alteryx Alumni (Retired)

Here's my solution. Always fun tweaking a report to get it just right

Spoiler
2020-08-24_10-22-28.png

 

patrick_digan
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1598291436205.png

 

cblazer
6 - Meteoroid

Definitely have some additions to the reading list after this one! 

Spoiler
230 Image.png
paulfound
11 - Bolide
Spoiler
PaulFound_0-1598305257909.png
PaulFound_1-1598305306450.png

 

LHolmes
9 - Comet

***Updated solution yxzp to account for additional dual authors that the embedded output leaves out.***

 

Probably some opportunity to streamline the parsing. The plus side is more documentation 🙂 

Fun challenge, loved playing with the charting tools and reporting tools.

 

Spoiler
230 - Solution.PNG
230 - Report.PNG

 

Qiu
21 - Polaris
21 - Polaris

Caught for the the author name part.

Spoiler
en-230.PNG