Get Inspire insights from former attendees in our AMA discussion thread on Inspire Buzz. ACEs and other community members are on call all week to answer!
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

Case Sensitive/Insensitive Joins

I've come to realize that the JOIN tool is case-sensitive by design but it would be helpful if you could turn that behavior on/off (via checkbox?) within the JOIN tool.  For those of us that work predominantly in database environments that are not case-sensitive, this default behavior has caused me problems many times.  Having to force the case to either upper or lower upstream of the JOIN on both flows in order to ensure a successful join is an extra step that would not be necessary if you could disable case-sensitive with a checkbox.

13 Comments
RZhong
6 - Meteoroid

Yeah, it would be nice if we could have the option to select whether we want case sensitive or insensitive in JOIN. 

AlteryxCommunityTeam
Alteryx Community Team
Alteryx Community Team
Status changed to: Accepting Votes
 
AshRez
7 - Meteor

It was suggested on 2017, and Alteryx team tagged it as "coming soon" in 2017. here

https://community.alteryx.com/t5/Alteryx-Designer-Desktop-Ideas/Case-insensitive-join/idi-p/54124

 

7 years and counting, maybe we can get this feature after another 70 years. 😜