Join Tool: Why a Record Didn't Join?

[DultonM]

Have you ever used a Join tool with several (or many) Join fields, looked at the the L and R outputs and wondered, why didn't these records join? When there are many columns in your data, this can be a hard question to answer. It would be very handy if Alteryx could somehow report the Field(s) that each record failed to join on (perhaps as an optional added field to the L and R outputs).

[craigbeach]

I second this. Also, if there was a way to tell what duplicated. 

Joins were big problems for me getting started with Alteryx, due to records not joining or getting duplicated.

I combat that problem these days by using the Find and Replace tool frequently to append a flag, then I filter out records that didn't get flagged. Find and Replace is optimized for 100K records or less, so this is problematic when I'm working on big data problems. 

Great suggestion, Dulton!

[KylieF]

We appreciate your feedback! If you haven’t yet be sure to check out our updated Submission Guidelines as it goes over our idea boards and the requirements to reach product in a bit greater detail. Be sure to check out the other product idea boards as well as like any other ideas that would benefit you!