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

binuacs
ポラリス
スポイラ
binuacs_0-1678145654698.png

 

TonyAndriani
コメット

Pretty straightforward without needing a cross join. I spent more time replicating the output than actually finding the matches. I'm interested in seeing the solution to understand why the output has composite keys and why they are shown twice in slightly different forms.

 

スポイラ
TonyAndriani_0-1678157904903.png

 

sergejs_kutkovics
コメット

My try :)

スポイラ
sergejs_kutkovics_0-1678180200684.png

 

FrederikE
パルサー
スポイラ
FrederikE_0-1678182030956.png

 

Sebastian_Chaieb2
10 - Fireball
10 - Fireball

I am not sure if my approach is correct, however I  have exact match 

スポイラ
Sebastian_Chaieb2_0-1678188054324.png

 

François_Rs
アステロイド
スポイラ
Franois_Rs_0-1678194096140.png

 

Flo_P
コメット
スポイラ
Interesting challenge but feel like there's some info missing on frames in the results.
Flo_P_0-1678199018461.png

 

ahsanaali
ボリード
スポイラ
ahsanaali_1-1678199647244.png

A no Join solution for a change :) 

alacoume
コメット

I have discovered new options on concatenete in the summarize component!

Erlina
アトム

Couldn't figure out the sorting, but the desired components are all there. This took a couple of tries though to figure out. 

スポイラ
Erlina_0-1678217178794.png