In case you missed the announcement: The Alteryx One Fall Release is here! Learn more about the new features and capabilities here
ACT NOW: The Alteryx team will be retiring support for Community account recovery and Community email-change requests after December 31, 2025. Set up your security questions now so you can recover your account anytime, just log out and back in to get started. Learn more here
community Alteryx IO MyAlteryx
alteryx Community
Search
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 
Close
Start Free Trial

Alteryx Designer Desktop Ideas

Share your Designer Desktop product ideas - we're listening!
Submitting an Idea?

Be sure to review our Idea Submission Guidelines for more information!

Submission Guidelines

Join Tool Unmatched Field Value(s) Added to Left/Right Output Results

Status: New Idea Submitted by on ‎01-22-2025 02:19 PM
Comment

The Join Tool tells you which records did not match (Left and Right) but it does not tell you what fields it did not match on.  This could quickly help the analyst determine which fields they need to look into to determine why there are unmatched records.  When joining on 5+ fields it becomes difficult to determine why some records did not match without manually inspecting each record which is time consuming.  The column title could be: Unmatched Field(s) and the values should be concatenated separated by commas.

See more ideas labeled with:
Labels