Show rows that are left out in the join function

[esabay]

Hi All, 

How do I show rows that were left out when using the join function:

Table 1:

Great Cat	Land
Talkative Horse	Water
Funny Dog	Land

Table 2:

Great Cat	abc123@mail.com
Talkative Horse	def456@mail.com

Result after using join:

Great Cat	Land	abc123@mail.com
Talkative Horse	Water	def456@mail.com

How do I see the the "Funny Dog" after using the join function. In my live data, Alteryx seems to have excluded items without email addresses. 

Thank you

[lbardoe]

Is this using the Join tool!

Because when you use the Join tool the items that cant be matched are returned through the Left or Right elements depending on what source table (ie Left or Right) cant be matched.

[binuacs · Accepted solution]

@esabay Check the L output anchor from the join tool

[esabay]

Ah that was very dumb of me sorry. Got it now thank you for the replies