Challenge #71: Recreate SQL Joins in Alteryx

[StevenBetts]

I like this one!

[Ukashi]

Hello, 

Thank you for niece challenge. 

Took straightforward route :)

Spoiler

[shoesnsocks4]

I liked this one!

[luciebrett]

Nice challenge :)

[kelly_gilbert]

Spoiler

Since I had a SQL background, it took me a while to "get" joins in Alteryx - one SQL join in some cases required two tools!

Note, in the screenshot, the formula tools are not necessary for the solution - I used them to aggregate the results so I could check them against the solution all at once.

[svenk]

My Solution!

[danilang]

Nice.  Of course the Venn diagrams in the descriptions kinda give it away

Spoiler

I used 3 different initial joins just to make it obvious where all the connections are coming from 

Dan

[kat]

Spoiler

[KOBoyle]

Solution attached.