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

andrewgu
Alteryx
Alteryx

Solved in Designer Cloud, collaborative approach with Jeremy and Leo!

 

andrewgu_0-1678409324266.jpeg

 

m_v
8 - Asteroid

I got over 10 years' experience in supply chain and this is the most messy tracking system I've ever seen. Solution attached!

mattnason1
9 - Comet
Spoiler
mattnason1_0-1678463933737.png

 

I definitely didn't get to the match position as elegantly as I could have.  Will be interesting to see how others did it.

SandroGerber
8 - Asteroid
Spoiler
SandroGerber_0-1678482906645.png

 

tammybrown_tds
9 - Comet

I do this a lot for my job...multi-joins can definitely be confusing sometimes.  I obviously didn't use the same technique that was used to do the sample output, because I don't have match keys, etc.

 

Spoiler
tammybrown_tds_0-1678487927673.png

 

subhajit843
8 - Asteroid

Here it is!!!

Kusk
8 - Asteroid

Challenge Completed

patrick_digan
17 - Castor
17 - Castor
Spoiler
patrick_digan_0-1678714956081.png

 

Colintermeer
8 - Asteroid

Answer

myastarling
10 - Fireball

Here's my solution. 

myastarling_0-1678737866133.png