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
Solved! Go to Solution.
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.
@esabay Check the L output anchor from the join tool
Ah that was very dumb of me sorry. Got it now thank you for the replies