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 #315: The One Where Everyone Talked

kelvin_law1
9 - Comet

Here is my solution:

Spoiler
kelvinlaw_1-1650347404232.png

 


 

usmanghayoor
8 - Asteroid
Spoiler
usmanghayoor_0-1650350636337.png

 

PhilipMannering
16 - Nebula
16 - Nebula

¯\_(ツ)_/¯

 

Spoiler
PhilipMannering_0-1650370156130.png

 

RolandSchubert
16 - Nebula
16 - Nebula
Spoiler
315.jpg
Diederik_vanderharst
8 - Asteroid

Voila

Spoiler
Schermafbeelding 2022-04-19 om 14.33.14.png

Pawel_Paleczny
9 - Comet

PawelPaleczny_1-1650372460463.jpeg

 

NicoleDuhamel
8 - Asteroid

My solution - after I got to the desired output I got a bit carried away and also did the lines in the top episode broken down by character...

 

 

Spoiler

NicoleDuhamel_1-1650372990795.png

NicoleDuhamel_0-1650372855169.png

NicoleDuhamel_2-1650373042188.png

 

 

 

Watermark
12 - Quasar
12 - Quasar

Ok, I spent ENTIIiiiiirrrrely tooooooo much time embelleshing the requirements, adding counts, and putting the results in report formats. I actually created 2 full categories, one for "LINE" counts, and a separate one for "WORD" counts.  I definitely could have kept going and added polish to the reports (headers, footer, etc) but figured I'd already kind of beat this horse. 

 

Spoiler
MT Solution 315.jpg

Spoiler
MT Solution 315 Line Cnt.jpgMT Solution 315 Word Cnt.jpg

  

  

dbrownsc
7 - Meteor
Spoiler
A little shortcut but still looks good.


dbrownsc_2-1650381938386.png

 

 

njusko
6 - Meteoroid

Here's my take.

 

Spoiler
Capture.JPG