Community Spring Cleaning week is here! Join your fellow Maveryx in digging through your old posts and marking comments on them as solved. Learn more here!
The Product Idea boards have gotten an update to better integrate them within our Product team's idea cycle! However this update does have a few unique behaviors, if you have any questions about them check out our FAQ.

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

Add a checkbox in the Join/Join Multiple Tools to join or not join NULL

Alteryx is unlike many BI tools in the sense that it joins NULL. It is difficult to think of another platform that has this behaviour. Either people know about this and work around it or they don't and their joins are a ticking time bomb. Please add a check box to the Join and Join Multiple tools to allow or prevent joining NULL. This will serve to remove the need for workarounds as well as educate users about this default behaviour.

4 Comments
KylieF
Alteryx Community Team
Alteryx Community Team

Thank you for the feedback and idea!

 

This brings up a really interesting point about teaching our users about default behavior and it good to know in regards to the join tool and how we can improve the process for users coming from other system. I'm sure our product team will also appreciate the insight on how many users would benefit from an update like this, so to any users who come by be sure to like this idea if it would be beneficial to you.

YEM
8 - Asteroid

Potentially this can be a session setting so all tools that use an "equality test" are impacted.

Example:

formula tool 1 == null returns false in Alteryx... but in SQL it would return null.

It can be expanded to multi-row formula, filter tool, any tool where we can use boolean logic.

 

phoebe_kelley
9 - Comet

yes please! I run into this often and have to figure out each time my join blows up that there was a null record somewhere.

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes