idea Case Insensitive Join in ArcGIS Pro Ideas

Case Insensitive Join

PärSmårs — Wed, 27 Jul 2011 09:07:37 GMT

If at all possible, I would like to see a checkbox somewhere on the Join Data dialog box in ArcMap, a box you could check to get a join that was case insensitive.

Let's say you have two text fields you want to join and one of the fields have say, Camel Case type text entered while the other does not, and that you just wanted to do a "quick'n'dirty" test of something, then it's a tad annoying the default is a case sensitive join.

Re: Case Insensitive Join

DamonPettitt — Mon, 24 Feb 2014 13:55:35 GMT

I think the bigger problem here is that if you were to join using personal geodatabase feature classes/tables, a case insensitive join happens, whereas a join using file geodatabase feature class/table happens with case sensitivity. ArcMap, however, doesn't tell you that this is happening, so I think a lot of folks could be unaware that their joins may or may not be doing what they think.

At a minimum, some warning should be shown for folks joining with file geodatabase items. Ideally, file geodatabase should allow for case insensitive joins.

Re: Case Insensitive Join - Status changed to: Already Offered

DrewFlater — Fri, 27 Jun 2025 00:24:14 GMT

Use the Join one To first join operation of Add Join for a case insensitive join.

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/add-join.htm#:~:text=One%2Dto%2Dfirst%20joins%20are%20not%20case%20sensitive%3B%20one%2Dto%2Dmany%20joins%20are%20case%20sensitive.