Alteryx: Problems with Joins

Category:
Question ID: 109868
2
0

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?

Marked as spam
Posted by (Questions: 17, Answers: 0)
Asked on October 21, 2020 10:53 am
6 views
Answers (1)
2
Private 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.

Attachments:
Marked as spam
Posted by (Questions: 0, Answers: 17)
Answered on October 21, 2020 4:55 pm