In the Add Join tool, choose if the join will be case sensitive or case insensitive.
Related: Why aren't one-to-first joins case-sensitive?
The Join Operation parameter has three states to adjust the cardinality. The default is blank and will allow the data source to attempt a one-to-many join. The Join one to many option will work only on specific data sources that have an Object ID field. The Join one to first option will use the first match in the table, which may result in different outputs if the Object ID field is changed or the workspace the table is copied to changes. One-to-first joins are not case sensitive; one-to-many joins are case sensitive.
https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/add-join.htm
Sign in to post, follow content, and more. New here? Register for free.
