Advent of Code is back! Unwrap daily challenges to sharpen your Alteryx skills and earn badges along the way! Learn more now.
community Alteryx IO Mission Control
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
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

Case Sensitive/Insensitive Joins

Status: Accepting Votes Submitted by on ‎09-25-2015 10:58 AM
13 Comments (13 New)

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.

See more ideas labeled with:
13 Comments
RZhong
6 - Meteoroid
‎05-08-2020 02:19 PM

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
‎08-31-2022 05:13 PM
Status changed to: Accepting Votes
 
0 Likes
AshRez
7 - Meteor
‎03-14-2024 01:38 PM

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. 😜 

0 Likes
Labels