Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
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
14 - Magnetar
14 - Magnetar

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!