I am having difficulty understanding joins in Alteryx. I have used the in database tools primarily and it allows the user to specify what type of join they would like (left, right, inner, outer) but on the regular join tool, it does not. How would I go about accomplishing each of these joins?
Answer:
When using the non-in-database join tool in Alteryx, to complete a left join, a right join, or a full outer join you must accompany the join tool with a union tool following it.
For a left join: use a join tool then attach the left output “L” anchor AND the “J” anchor to a union tool.
For a right join: use a join tool then attach the right output “R” anchor AND the “J” anchor to a union tool.
For a full outer join: use a join tool then attach the right output “R” anchor, the left output “L” anchor, AND the “J” anchor to a union tool.
