Challenge #71: Recreate SQL Joins in Alteryx

[KevinTang]

done, good refresh of the join function

[mpennington]

Solution attached.

Spoiler

[AngelosPachis]

Challenge #71 is done

Spoiler

[deepaprash]

Done

[cc000072]

Here is my solution.

Spoiler

[JonathanW]

Solved

Spoiler

[AnaisComyn]

Done !

[treepruner]

I get that maybe you want to do something with the unmatched records on the outer join, but I really wish I could just specify the join type in the tool, too.

[jarrod]

This is one of the first things i did with Alteryx without ever learning the SQL joins. Now i use it every day.

Spoiler

[Verakso]

A query walks into a bar, when some tables said

Spoiler

Nothing a little join and union tool can't handle 

Still Climbing
/Verakso