Challenge #71: Recreate SQL Joins in Alteryx

[DRomero]

Kept mine super basic.

[Joe_Mako]

Inspired by @NicoleJohnson I created a simple general use macro, for more interface action practice.

Spoiler

Is there a know technique for selecting zero records and zero fields? The attached is what I came up with.

[SeanAdams]

What a hoot! Your digital dog ate your digital homework. You should see if you can use your digital assistant to schedule digital training for that naughty pet! :-) Have a good Thu Mark!

[Garrett]

Threw in a "Join Multiple" for a one tool "Full Join" just to spice it up.  Otherwise nothing exotic.

[jacob]

uploaded this one without a picture as there is nothing special to show..

[LordNeilLord]

A nice refresher

Spoiler

[MattD]

Here's a solution!

Spoiler

[mceleavey]

Nice. I've actually built this previously as a macro, but I've simplified it here as an analytic app that allows you to choose the join type on the fly.

Spoiler

I began by creating a text input that represents the join type:

And then a separate list of all join types: 

This I applied to a drop-down list which actioned the first file to update the value with the value selected:

I then appended this to the two input files:   

I then placed a join tool to join them together on the key field:  
Each output combination was taken to represent each join type accordingly:

      
I then unioned the outputs of all joins, applied a filter to only show records that matched the join type and output as HTML:


This will output only those records that are the result of the join type selected in the dropdown.

This should now be dynamic, so you can run the app, choose your join type, and the corresponding output will be shown in HTML:

[nick_ceneviva]

Solution attached