Advent of Code is now back for a limited time only! Complete as many challenges as you can to earn those badges you may have missed in December. Learn more about how to participate here!
Start Free Trial

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 #361: Cross Joins at Bedtime

gerda
8 - Asteroid
Spoiler
gerda_0-1678127279777.png

 

Here's the solution - kachow!

JamesCharnley
13 - Pulsar
Spoiler
JamesCharnley_1-1678127499358.png

 


 

Didn't really enjoy

braveraj
11 - Bolide
Spoiler
braveraj_0-1678127548851.png braveraj_1-1678127571767.png

 

 

DataNath
17 - Castor
17 - Castor

My solution to #361.

 

Spoiler
DataNath_0-1678128629998.png
Clifford_Coon
11 - Bolide

My Solution (no composite keys required) matching accessories to frames. simple hint: go vertical.

Added section creating the requested output.

Spoiler
Challenge_361.jpg

balajilolla1
8 - Asteroid
Spoiler
Solution Attached
balajilolla1_0-1678130336257.png

 

BS_THE_ANALYST
15 - Aurora
15 - Aurora

Interesting 

Spoiler
BS_THE_ANALYST_0-1678134246386.png

 

 

All the best,
BS

LinkedIN

Bulien
Kenda
16 - Nebula
16 - Nebula
Spoiler
Kenda_0-1678135328923.png

 

PhilipMannering
16 - Nebula
16 - Nebula
Spoiler
PhilipMannering_0-1678140152504.png

 

olga_strubbe
11 - Bolide
Spoiler
olga_strubbe_0-1678140775147.png

 

I followed a similar approach as @RolandSchubert  - I took the last formula tool out (thus, concatenated using comma only), as I did not think the field with [] was really needed for the solution.  It is extra to have, but it does not drive the solution.  Thank you, Roland, for trailblazing the solution on this!