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
