Alteryx: Problems with Joins
| ♥ 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 |
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 Captain Tester (Questions: 0, Answers: 17) Answered on October 21, 2020 4:55 pm
|
