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 insensitive join

Hey all,


The join tool currently does not allow case-insensitive joins, but the find/replace tool does.    Additionally- even if both sides are identical, the join tool will not join "Sean's house" to "Sean's house" because of the non-letter character in the middle.    Finally - if one side is a string(2), and the other is a vString(200) - even if you have a single identical character on both sides you get uncertain outcomes unless you force the type


Please could you consider amending the join tool to include 3 new options or capabilities:

- Case insensitive join

- Allow full Unicode character set in join

- Full match across text types (irrespective of string size) - this would allow a string(2) value to match to a string(100) value as long as the string(100) value only has the same 2 characters in it as the string(2) value


That would remove a load of work from every text-join that's being done on every canvas we do.


Thank you 




5 - Atom

Here is a case study of why this is needed.


 Left join:

Course nameNumber of students 
MSc in Economics & Maths50
MSc in Economics and Maths50
MSc in Economics And Maths50


I then export this and group them together to create a mapping table (using Tableau which is not case sensitive and gives me this mapping table (right join):

Course nameClean course name
MSc in Economics and MathsMSc in Economics & Maths
MSc in Economics & MathsMSc in Economics & Maths


Inner join output using join on course name: 

Clean course nameNumber of students 
MSc in Economics & Maths100


So I loose the 50 students from the left table because of the capital A in 'And'. Once I've done some manual checks I realise this issue and have to add this to my mapping table. 


Using the find replace tool or using a formula to do mapping is not an option as I have hundreds of course names to map. If I convert everything to lower case I loose the capitalisation which I need.


If anyone has any suggestions to make this less painful in the absence of the insensitive join please let me know. 




7 - Meteor

Sean: Yes, it wouldn't take much to toggle case sensitivity on & off--Alteryx is full of toggles! But seriously, the comments here are shockingly unrealistic. In a busy knowledge-work environment where engineers need datasets fast, nobody wants to spend time fussing with upper & lowercase shenanigans when there's an app for that. And don't get me started about how Alteryx needs to stop with the fussy date-handling!

11 - Bolide

How I'd like it done...





8 - Asteroid

If there is a risk of compromising functionality this might be part of a "fuzzy join" tool, which could definitely be another popular addition.

7 - Meteor

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