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

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 

Sean

 

 

25 Comments
zoesaleh
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. 

 

Thanks,

Zoe

DataMeister
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!

hroderick-thr
11 - Bolide

How I'd like it done...

hroderickthr_0-1650547051922.png

 

 

 

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

AshRez
7 - Meteor

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