Challenge #71: Recreate SQL Joins in Alteryx

[Sashikumar]

Join Solution.

Spoiler

[dombaikamilla]

Spoiler

[byagelski]

my solution

[AndrewDearstyne]

My solution.

[apathetichell]

I had fun with this one and have provided both a standard workflow and an analytic app which takes in a users SQL join preference. The output is a bit messy on that one as seemingly multiple browse windows are always created and it can take a second to find the correct table in the browse window. Output would be cleaner as a chained analytic app - so perhaps that's the next step - or a glimpse a weekly challenge yet to come?????

[Pang_Hee_Choy]

solution

[Luke_C]

Spoiler

 

[JP_SDAK]

This was a great challenge - surprised it didn't include inner join -since it was in the description of the challenge, I decided to include it.

Spoiler

[rcarog]

Solution attached.

[Toons]

My solution :

Spoiler