Case sensitivity when using data mesh

Jacqueline Ennis

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

Jacqui

Jacqueline Ennis

Perfect. Thank you so much!

Paul Newcome

You would need to use a helper column, and this helper column would be what provides your match.

=UPPER(LEFT(ID@row)) + RIGHT(ID@row, LEN(ID@row) - 1)

Jacqueline Ennis

Perfect. Thank you so much!

Paul Newcome

Happy to help. 👍️