Case sensitivity when using data mesh


I set up a Data Mesh that is working quite well. Nurses enter their credential information and we use DataMesh to add other human resources information of record - including manager's email. The DataMesh is keying of of the common field of User ID. We noticed that for many of the nurses the match didn't work and also notice that the common problem was that the source file has all user id's starting with a capital letter and the match only fails when the user does not start their user ID with a capital letter.

My question - is there a way to get Data Mesh to ignore case sensitivity? Or is there a routine that I can use to change the first letter in all user id's to a capital?

Thanks in advance


Best Answer