Weekly Challenge

Solve the challenge, share your solution and summit the ranks of our Community!
IDEAS WANTED

We're actively looking for ideas on how to improve Weekly Challenges and would love to hear what you think!

Submit Feedback
We've recently made an accessibility improvement to the community and therefore posts without any content are no longer allowed. Please use the spoiler feature or add a short message in the message body in order to submit your weekly challenge.

Challenge #71: Recreate SQL Joins in Alteryx

Highlighted
5 - Atom

Kept mine super basic.

Highlighted
12 - Quasar
12 - Quasar

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

Spoiler
c71.png
Is there a know technique for selecting zero records and zero fields? The attached is what I came up with.
Highlighted
16 - Nebula
16 - Nebula
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!
Highlighted
Alteryx Certified Partner

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

Highlighted
Alteryx Partner

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

Highlighted
Alteryx Certified Partner

A nice refresher

 

Spoiler
Weekly Challenge 71.png
Highlighted
Alteryx Community Team
Alteryx Community Team

Here's a solution!

 

Spoiler
Solution.jpg

 

Highlighted
Alteryx Certified Partner

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:
Join Types.PNG
And then a separate list of all join types: 
All joins.PNG
This I applied to a drop-down list which actioned the first file to update the value with the value selected:
Apply join types to selector.PNG
I then appended this to the two input files:   
Appending Join Types.PNG
I then placed a join tool to join them together on the key field:  Join data and take output combinations for each SQL join type.PNG
Each output combination was taken to represent each join type accordingly:

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

Join, Filter and Output.PNG
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:

Output 1.PNGOutput 2.PNGOutput 3.PNG

 

Highlighted
7 - Meteor
 
Highlighted
Alteryx Certified Partner

Solution attached