Showing results for 
Search instead for 
Did you mean: 

Alteryx designer Discussions

Find answers, ask questions, and share expertise about Alteryx Designer.
Announcement | We'll be doing maintenance between 9am-11am MT on Saturday, January 25th, which may impact your experience. Thanks for your patience as we work on improving the community!

Help with Join/Union


Hello - I am having trouble getting the right results from my join.  I know exactly what I need to happen, but I've failed at selecting the correct way to make this happen.  I've attached screenshots in a document (as I'm unclear how to show them in the actual post).  I'm very much a rookie, so hopefully someone sees quickly what I need to do!

Thank you!



Hi @jseaburn you would use the join tool, formula tool, and union tool. The flow would look like this: 




Where the formula tools would insert whatever value you wanted for the unmatched records. You will probably also have to edit which fields are included in the middle join, so all three input sources to the union tool have the right number of fields.

Alteryx Certified Partner
Alteryx Certified Partner

Hi @jseaburn 


You can also use the Join Multiple Tool. The output is always the full outer join of the records, unless you check the option to "Only Output Records that Join from All Inputs".



Thank you both for the suggestions!  I ended up using the Multi-Join tool.  The input didn't give me exactly what I wanted so I used a formula and select tool to make my way through and was able to achieve what I needed!  I'm not sure it's the "best" way..but it works   Thanks so much!