What type of joins can the Join Tool specifically do?
Hi
You can read this article
https://help.alteryx.com/20221/designer/join-tool
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:
And watch a video to know how to use:
https://www.youtube.com/watch?v=jk7vESsOVhY