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.
community Alteryx IO Alteryx.com
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 Insensitive Joins

Status: New Idea Submitted by on ‎09-21-2023 01:55 PM
3 Comments (3 New)

The Find Replace tool has a checkbox to do a case insensitive find. It would be fabulous if the Join and Join Multiple tools had a similar checkbox.

 

I frequently have to create a new field in each data stream, convert the data I want to join on to upper case, perform the join and remove the extra "helper" fields. Using the helper field is needed in my case in order to preserve unique capitalization (i.e., acronyms within the string, etc.). 

See more ideas labeled with:
3 Comments
collin_pace
9 - Comet
‎10-20-2023 07:29 AM

I agree, would be a quality of life improvement.

0 Likes
haraldharders
9 - Comet
‎10-20-2023 12:35 PM

I agree. And I would like to add another feature which would help: Do whitespace-independent joins, ignoring all white space (\n, \r, \t, \r).

AshRez
7 - Meteor
‎03-14-2024 01:37 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