Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
New content is available in Academy! You may need to clear your browser cache for an optimal viewing experience

Challenge #71: Recreate SQL Joins in Alteryx

Highlighted
Asteroid
 
Highlighted
Asteroid

With my background as a developer and database administrator this one was the easiest so far. I enjoy remembering good old times.

Highlighted
Alteryx Partner

Challenge 71- Complete. A nice intermediate. 

Highlighted
Alteryx
Alteryx

The hardest part was making it neat ... wireless connection all the way, sorry will have to download if you want to see what is connected to L and R.

 

Spoiler
71_challenge.jpg
Highlighted
Asteroid

Nice comparison! Did it as a cheat sheet for myself and the wireless connection option proved to be really useful to get a clean look.

 

 

Spoiler
Spoiler

Alteryx_Join.PNG

 

 

 

 

Highlighted
Asteroid

Same approach here to get a clean look @CaraI. Wireless connections for the win!

Highlighted
Alteryx
Alteryx

@damc - Love the colored containers!  Makes it even cleaner and easy to read!

Highlighted
Alteryx Partner
Spoiler
71. Data Preparation.PNG
Highlighted

Here is my approach. Bit untidy one

Asteroid
Spoiler
Spoiler 

Capture.PNG