Challenge #71: Recreate SQL Joins in Alteryx

[OllieClarke]

I really en-join-ed this challenge

Spoiler

[Karam]

Solution attached.

Spoiler

[cplewis90]

Always fun to show how Alteryx can do similar things to other programs and make them easy to repeat!

Spoiler

[ChrisMelck]

I am no longer doing these in order...this may or may not be a good idea

[nini]

My Solution:

[Kenda]

Spoiler

[Jonathan-Sherman]

Challenge 71 is done!

Spoiler

[Sajeel_Kershi]

Nice to visualise the different types of joins - the time consuming part was splitting the main graphic into  7 sub images and settting them up as the background image to the comment box and placing the browser for each type of join output on top.

Not sure if these images transfer to somebody else opening the workflow. The solution had an embedded image so assuming its saved with the .yxmd file

I like the idea of making it into an app which a number of people have done; so will give that a go

[JonathanAllenby]

Here's my solution to challenge 71.

[Ozzy_Campos]

Super simple, but it's good for me to review - I work with people that make unnecessarily complicated SQL queries, and have trouble the intuitive Alteryx way vs. the error-prone SQL way.