Challenge #71: Recreate SQL Joins in Alteryx

The solution to last week's challenge is HERE!

SQL Joins.jpg

Today’s challenge is for all of our analysts and data scientists who used SQL in a past (or their current) lifetime! Using the schematic above, can you recreate all the SQL joins with the Alteryx Join Tool and the datasets we have provided?

Spoiler

Hint: this should be easier for those of you who have mastered the Union Tool.

challenge_71_start_file.yxmd

challenge_71_solution.yxmd

Join

Advanced

Intermediate

Data Preparation

Accepted answers

All comments

Kiwi_Li

Hello! Here is my solution for the challenge #71 and the beginning of my Alteryx journey.

Spoiler

challenge_71_KL.yxmd

Erlina

Spoiler

Here's my solution... Challenge 71 Solution.png

challenge_71_Solution_EC.yxmd

anniecasey

Spoiler

Definitely over thought this one at first! Great practice though.

ACasey Challenge 71.yxmd

lyon_abido

Please let me know if I accidentally duplicated any joins by mistake! haha

challenge_71_solutions.yxmd

muddiin96

Alteryx Challenge 1.jpg

Spoiler

lyon_abido

This was a nice challenge! It really helps to visualize all the different SQL joins.

challenge_71_solutions.yxmd

keynguyen

Spoiler

challenge_71_start_file.yxmd

Thomas_Wells_2dot0

Solution attached. I didn't think to do this with only one Join, and multiple Union tools like some of the other posts... Oh well, using wireless connections cleaned up the workflow a bit