Challenge #71: Recreate SQL Joins in Alteryx

[SylwiaDragon]

Done

[Shifty]

I enjoyed this challenge a lot more than I should really admit.  I know nothing about SQL but I hear about joining in SQL so frequently that this was a fun exercise.

Spoiler

[James_Driver9]

Spoiler

[dbAlfa]

Here my solution.

[JamesCharnley]

Teaching a lesson on joins soon so this was nice practise

Spoiler

[DataNath]

My solution to #71.

Spoiler

[scoles0617]

My solution:

[dYoast]

Mostly easy.  Some configuration changes to get the order to match.

Spoiler

[TonyAndriani]

Just for fun I did this one a little differently. By the way, I have never heard of a left or right join as anything other than other names for left outer and right outer join. In the databases I've worked with, either version of the name gives the same result.

Spoiler

This method does a bettter job of replicating the result you would get from a database outer join without having to use Select tools to rename columns. The one difference is that this method would not match on null keys.

[binu_acs]

solution attached