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.

Weekly Challenge

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

Also available in | Français | Português | Español | 日本語

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

Submit Feedback

Challenge #71: Recreate SQL Joins in Alteryx

5 - Atom

Kept mine super basic.

12 - Quasar

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

Is there a know technique for selecting zero records and zero fields? The attached is what I came up with.
17 - Castor
17 - Castor
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!
11 - Bolide

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

6 - Meteoroid

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

15 - Aurora

A nice refresher


Weekly Challenge 71.png
Alteryx Alumni (Retired)

Here's a solution!




Former Alteryx, Inc. Support Engineer, Community Data Architect, Data Scientist then Data Engineer
17 - Castor
17 - Castor

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.

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



7 - Meteor
11 - Bolide

Solution attached