Functions of a join tool

[jandreasson]

What type of joins can the Join Tool specifically do?

[BRRLL99 · Accepted solution]

Hi

You can read this article

https://help.alteryx.com/20221/designer/join-tool

[grazitti_sapna]

Hi @jandreasson , Join tool gives us 3 outputs, Left(unmatched records from left input), Right(unmatched records from right input) and Inner join(matched records from both inputs). And we also have multiple join tool which can be used to join multiple sources and by default it gives us all matched and unmatched records but you can change configuration and have only matched records. For further information you can check the below link:

https://help.alteryx.com/20221/designer/join-tool

And watch a video to know how to use:

https://www.youtube.com/watch?v=jk7vESsOVhY