An Inner Join pulls through records that matched from the left input (table 1) to the right input (table 2). In this type of join, the values from the left input that do not match to values in the right input are then left out.
The great thing about doing an Inner Join in Alteryx is that we get all the records that matched in the J output anchor, any records that didn’t match from the left input are in the L output anchor, and any records that didn’t match from the right input are in the R output anchor.
Inputs:
Outputs:
Previous blog entries also cover the types of joins and how to configure the join tool. Hope this blog provides you with a quick overview and helps you better understand Inner Joins, Left Only Joins, and Right Only Joins in the context of Alteryx! Until next time – let's analyze away!