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

andrewgu
Alteryx Alumni (Retired)

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
11 - Bolide

Here's my solution. 

myastarling_0-1678737866133.png