Missed the Q4 Fall Release Product Update? Watch the on-demand webinar for more info on the latest in Designer 24.2, Auto Insights Magic Reports, and more!

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
Polaris
Saqueador
binuacs_0-1678145654698.png

 

TonyAndriani
Cometa

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.

 

Saqueador
TonyAndriani_0-1678157904903.png

 

My try :)

Saqueador
sergejs_kutkovics_0-1678180200684.png

 

FrederikE
Pulsar
Saqueador
FrederikE_0-1678182030956.png

 

Sebastian_Chaieb2
10 - Fireball
10 - Fireball

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

Saqueador
Sebastian_Chaieb2_0-1678188054324.png

 

François_Rs
Asteroide
Saqueador
Franois_Rs_0-1678194096140.png

 

Flo_P
Cometa
Saqueador
Interesting challenge but feel like there's some info missing on frames in the results.
Flo_P_0-1678199018461.png

 

ahsanaali
Bólide
Saqueador
ahsanaali_1-1678199647244.png

A no Join solution for a change :) 

alacoume
Cometa

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

Erlina
Átomo

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

Saqueador
Erlina_0-1678217178794.png