Bring your best ideas to the AI Use Case Contest! Enter to win 40 hours of expert engineering support and bring your vision to life using the powerful combination of Alteryx + AI. Learn more now, or go straight to the submission form.
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
Asteroide
Spoiler
gerda_0-1678127279777.png

 

Here's the solution - kachow!

JamesCharnley
Púlsar
Spoiler
JamesCharnley_1-1678127499358.png

 


 

Didn't really enjoy

braveraj
Bólido
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
Bólido

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
Asteroide
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
Bólido
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!